I was working from this information: http://www.1keydata.com/sql/sqlouterjoin.html
>What database are you using? I've never see that "+" notation before... > > >One thing I can suggest (without actually helping you) is to use >ANSI-style joins, which are done in the FROM clause, and not in the >WHERE clause. I find these to be much more expressive and sometimes >they are the only way to do something tricky, and you're getting close >to that now. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:267300 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
