If you can pull both result sets into ColdFusion through their respective data sources, you should be able to use a QofQ. A left outer join isn't supported in QofQ's, but there are work-arounds: http://www.bealearts.co.uk/blog/2007/06/20/how-to-do-an-outer-join-in-qu ery-of-queries/
~Brad -----Original Message----- From: Ben Doom [mailto:[EMAIL PROTECTED] Sent: Friday, December 14, 2007 10:12 AM To: CF-Talk Subject: Re: Compare two tables I don't think you can do a subselect in a QofQ (someone correct me if I'm wrong) so I think the easiest thing would be to pull both in and then walk the arrays. Brute force and inelegant, but .... is this something you need to do once, or is this something that must be done often? --Ben Doom Ian Skinner wrote: > Anybody have a creative way to compare data in two tables and find all > records in table A not in table B and vice-a-versa. The data share a > common key, 'License Number'. > > The trick -- Table A is in an MS Access Database and Table B is in a MS > SQL server database. They are not aware of each other and we can not > import the Access data into the SQL database at this time at least. > > TIA > Ian > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:294811 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
