That's ok, but for anyone else reading this. Although the sql is ok, it does end up being translated at the SQL server level with an inner join anyway.
And in this case a left outer join might be better, because the results might not be what you would normally expect. Just for the newbies reading this thread. Senior Coldfusion Developer Aegeon Pty. Ltd. www.aegeon.com.au Phone: +613 8676 4223 Mobile: 0404 998 273 -----Original Message----- From: Michael E. Carluen [mailto:[EMAIL PROTECTED] Sent: Wednesday, 20 September 2006 3:14 PM To: CF-Talk Subject: RE: How to get these query results Andrew, The sql with cfoutput I sent Matt would do what he needed, as he stated- period. I know how to do inner/outer joins, but wont do it just for the sake of doing it. But thanks for your good advise. Michael ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:253563 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
