So can you not do something like: select whatever from pur right join pro on pur.reg_firmno = pro.reg_firmno
(might be left -- I sometimes mix them up) Or is that not supported? Sorry, not a SQL expert and never used Oracle. --Ben Doom Ian Skinner wrote: > "Are there instances where pur.reg_firmno is not null but that there is > no matching pro.reg_firmno? If so, do you *not* want to pull these records?" > > There maybe and if so I would still want the available pur data. > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create robust enterprise, web RIAs. Upgrade to ColdFusion 8 and integrate with Adobe Flex http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:289634 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
