[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2711
  • Last Modified:


Can I use a FULL OUTER JOIN in Cold Fusion? It doesn't appear to be working.
3 Solutions
the Microsoft Access and Microsoft Access with Unicode drivers do not support FULL OUTER JOIN clauses. What is ur db?
Cold Fusion doesn't care.  SQL statements are all "pass-thru".  Your database must support it.
1) If you are talking Query of Query : ColdFusion does not support it.
2) MS SQL and Oracle support them.
3) (as mentioned above) MS Aceess does not support it.

Suggestion: If you want to run Full Outer Join make your Database to do the work, instead of query or query.

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

I think this is realted to:


Where I showed you that query of queries do not support it, you need to see if your database (I think you said DB2) supports it or not.
tammieRAuthor Commented:
I am in fact trying to pass this to DB2, via Client Access. I seem to get contradicting info as to whether or not the ISeries supports FULL Join's. Some sources say it's been allowed since version 4. Anyone know? I am still researching...
tammieRAuthor Commented:
I found it on the ISeries website...

DB2 UDB for iSeries SQL Programming Concepts V5R2

Simulating a Full Outer Join
Like the left and right outer joins, a full outer join returns matching rows from both tables. However, a full outer join also returns non-matching rows from both tables; left and right. While DB2 UDB for iSeries does not support full outer join syntax, you can simulate a full outer join by using a left outer join and a right exception join.

Featured Post

Important Lessons on Recovering from Petya

In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now