One way...
If you have a uniqueidentifier across both databases (it should be possible
to create one if you dont):
Merge the two tables into a new table using a union query, including all
fields from both tables. (mergedTable) (or create a view)
Select max(uniqueIDfield) as uniqueField, (all the fields that will be the
same in duplicates)
from mergedTable
group by (all the fields that will be the same in duplicates)
and put this into another table (table2) (or create a view)
then select * from mergedTable where uniqueIDfield in(select uniqueField
from table2)
and voila - you have your merged data...
HTH
Dan
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: 02 August 2001 00:49
To: CF-Talk
Subject: Inexact Duplicate queries
I'm trying to merge 2 databases together, an having problem with the inexact
duplicates.
I have no experience in this area, so anyone have any idea on how to do it?
Thanks in advance
Thanh
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
