I would do it this way :

select b.* 
from b
where b.id not in (select a.id from a)



>How about:
>
>select b.*
>from b
>left outer join a on b.id = a.id
>where a.id is null
>
>Carl
>
>On 6/21/2011 10:37 AM, Jenny Gavin-Wear wrote:
>> 

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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:345498
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Reply via email to