Just did this with an LDAP query and a SQL Server result set the other day.
UNION is what you want to use, as for flagging dups...UNION eliminates the duplicates so I don't know if you would need/want/be able/ to flag them. At 04:13 PM 7/3/2002 -0400, you wrote: >Let say I have 2 queries result sets from 2 different sources and I >want >to compare them. i.e. if there's a record different between them than that >record will be flagged in some way. Records that are the same are not >flagged. Is there an easy way to do this in a SQL statement? >The goal is to run a CFDIRECTORY on 2 different directories and show what >files are in one and not the other or what files in one are different in >size than the other. I'm sure I could write a sort mechanism in CF, but I >think that a SQL way would be more efficient if it exists. >Thanks > >Michael Dinowitz >Master of the House of Fusion >http://www.houseoffusion.com > > ______________________________________________________________________ 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
