> 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.
I think he's looking to find differences instead of combining everything. For instance, if there's a File1 in DirectoryA, there should be a File1 in DirectoryB. Also, they should be the same size. I should note that I did not include that in my query -- sorry. Just add the a.size = b.size in the ON clause. Ben Johnson ______________________________________________________________________ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.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
