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. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Download the latest ColdFusion 8 utilities including Report Builder, plug-ins for Eclipse and Dreamweaver updates. http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:289563 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
