Thanks John and Greg :)
>>-----Original Message----- >>From: Greg Morphis [mailto:[email protected]] >>Sent: 21 June 2011 18:45 >>To: cf-talk >>Subject: Re: SQL Query Problem >> >> >> >>if your tables are large, you'll probably see a better performance from >>select id from TableA a >>where not exists >>(select 1 from TableB b >>where a.id = b.id) >> >> >>On Tue, Jun 21, 2011 at 12:41 PM, John M Bliss >><[email protected]> wrote: >>> >>> select * from b where id not in (select id from a) >>> >>> On Tue, Jun 21, 2011 at 12:37 PM, Jenny Gavin-Wear < >>> [email protected]> wrote: >>> >>>> >>>> Two tables each containing a shared primary key ID. >>>> >>>> I am trying to create a query that lists records from table B >>that are not >>>> in table A. >>>> >>>> Many thanks, >>>> >>>> Jenny >>>> >>>> >>>> >>>> >>>> >>> >>> >> >> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:345496 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
