Posted on 2005-05-13
Last Modified: 2013-12-24
Can I use a FULL OUTER JOIN in Cold Fusion? It doesn't appear to be working.
Question by:tammieR
    LVL 11

    Expert Comment

    the Microsoft Access and Microsoft Access with Unicode drivers do not support FULL OUTER JOIN clauses. What is ur db?
    LVL 7

    Accepted Solution

    Cold Fusion doesn't care.  SQL statements are all "pass-thru".  Your database must support it.
    LVL 22

    Assisted Solution

    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.

    LVL 35

    Assisted Solution

    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.

    Author Comment

    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...

    Author Comment

    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.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Article by: kevp75
    Hey folks, 'bout time for me to come around with a little tip. Thanks to IIS 7.5 Extensions and Microsoft (well... really Windows 8, and IIS 8 I guess...), we can now prime our Application Pools, when IIS starts. Now, though it would be nice t…
    Periodically we have to update or add SSL certificates for customers. Depending upon your hosting plan you may be responsible for the installation and/or key generation. In the wake of Heartbleed many sites were forced to re-key. We will concen…
    In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…
    Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

    794 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    15 Experts available now in Live!

    Get 1:1 Help Now