Results 1 to 4 of 4
  1. #1
    Join Date
    Jun 2008
    Location
    India
    Posts
    96

    Unanswered: FULL JOIN in sybase

    does sybase support FULL JOIN ? If yes, it would be helpful for me if anybody give me an example query. also i wanted to know which version does support FULL JOIN ?

    i am using 12.0 version.

  2. #2
    Join Date
    Jun 2008
    Location
    India
    Posts
    96
    Any inputs ?

  3. #3
    Join Date
    Dec 2007
    Location
    London, UK
    Posts
    741
    The documentation lists LEFT, RIGHT but not FULL outer joins.
    http://manuals.sybase.com/onlinebook...394;pt=14394#X

    An outer join (including a FULL join) is shorthand for a join followed by a UNION. So it's always possible to achieve the same effect with or without the FULL JOIN syntax.

  4. #4
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    Code:
    SELECT columns
      FROM table1
    LEFT OUTER
      JOIN table2
        ON joinconditions
    UNION 
    SELECT columns
      FROM table1
    RIGHT OUTER
      JOIN table2
        ON joinconditions
    note that UNION will remove the dupes (rows which match)
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

Posting Permissions

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