Posted on Leave a comment

Fake a Left Outer Join with ColdFusion’s Query of Query

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")

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.