Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2004
    Posts
    13

    Unanswered: Full Outer join available in Informix?

    I have two tables (table1 and table2) that I want to return all records from both tables joining them on columnA, while showing all values from both tables. These two tables are not alike, so the Union query is out. Is there a Full Outer Join available in Informix?

    TIA,
    Jeremy

  2. #2
    Join Date
    May 2004
    Location
    New York
    Posts
    248
    SELECT ...
    FROM first_table OUTER second_table
    WHERE .....

  3. #3
    Join Date
    Sep 2004
    Posts
    13
    Thanks for the response. We ended up writing our own type of Full Outer join. When things slow down a little, I will try the syntax that you provided.

    Jeremy

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •