Re: [ACFUG Discuss] SQL Question
Assuming that you have properly joined the two tables you can try adding DISTINCT to the query. A proper join between the tables normally results in distinct rows being return. If you simply include the table names in the FROM clause, you will get a cross-product join which will result in many duplicates. A proper join eliminates the duplicates be only joining rows between the tables where a primary key = a foreign key. Sometimes you can join tables but still need to add DISTINCT ... SELECT DISTINCT * FROM tableA, tableB WHERE tableA.primaryKey = tableB.foreignKey Sincerely, Brooks Wilson Try not to become a man of success but rather to become a man of value. - Albert Einstein (1879-1955) Federal Reserve Bank of Atlanta · 1000 Peachtree Street, N.E. · Atlanta Georgia 30309-4470 404.498.8178 · fax 404.498.8239 · [EMAIL PROTECTED] Singles Concepts, Inc. [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 01/19/2007 02:56 PM Please respond to discussion@acfug.org To discussion@acfug.org cc Subject [ACFUG Discuss] SQL Question Hey CF Crew, I have a question concerning SQL; I have two database tables. I would like to merge and purge the two tables an end with result table that is free of duplicates. I was seeking a application written in CF. Thanks Michael gifsOwg9WWmJ2.gif Description: GIF image
RE: [ACFUG Discuss] SQL Question
If the two tables are the same layout (same columns), you have an easy solution: SELECT * INTO dbo.newTable FROM (SELECT * FROM table1 UNION SELECT * FROM table2) -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Singles Concepts, Inc. Sent: Friday, January 19, 2007 2:56 PM To: discussion@acfug.org Subject: [ACFUG Discuss] SQL Question Hey CF Crew, I have a question concerning SQL; I have two database tables. I would like to merge and purge the two tables an end with result table that is free of duplicates. I was seeking a application written in CF. Thanks Michael - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com -