"Murphy was an optimist!"
Fake a Left Outer Join with ColdFusion’s Query of Query July 14, 2006 6:29 amPosted by Doug McCaughan in : ColdFusion, Programming, Technology
Since a Query of Query only supports INNER JOIN syntax, many developers are left frustrated because the incredibly useful LEFT OUTER JOIN is unavailable. Alistair Davidson has come up with a solution using the support UNION syntax.
For those of you now asking "what is an inner join? What is a left outer join?" I have provided an explanation in pictures and words. (complete with a typo of the word "columns")trackback