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?
--Ben Doom Ian Skinner wrote: > I would guess you could rewrite the last bit as > and (pur.reg_firmno is null OR pur.reg_firmno = pro.reg_firmno) > or something similar. > > Is that what you were asking? > > --Ben Doom > > That works correctly for an inner join, but I need a right outer join since > the product table may not have a matching record for the pur75raw table, but > I need the pur75raw data whether there is a product match or not. When I > tried (pur.reg_firmno is null OR pur.reg_firmno = pro.reg_firmno(+)), I get > an Oracle error saying that outer(+) joins are not allowed in an OR or IN > clause. Unfortunately I am restricted to SQL92 join syntax since this is an > older Oracle version. > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| ColdFusion is delivering applications solutions at at top companies around the world in government. Find out how and where now http://www.adobe.com/cfusion/showcase/index.cfm?event=finder&productID=1522&loc=en_us Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:289625 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
