OUTER JOIN - Oracle/MySQL/Sybase
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: OUTER JOIN - Oracle/MySQL/Sybase

  1. #1
    Join Date
    Sep 2000
    Posts
    155

    I have an outer join query in Oracle like:

    select a.id, b.name
    from table1 a , table2 b
    wher a.id = b.id (+);

    I was wondering if we can write a query of this nature that
    would work on Oracle/MySql/Sybase/SQL Server. I mean.. just one query that would work on all the DBs. We do not want to write individual queries for each DB. Any ANSI format.....


    Thanks in advance!

  2. #2
    Join Date
    Nov 2000
    Location
    Baltimore, MD USA
    Posts
    1,339
    Unfortunately not... yet.

    SQL-92 provides a standard way of doing joins and outer joins in the FROM clause, but Oracle will not be supporting that standard until 9i.

    sorry,

    - Chris

Posting Permissions

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



Click Here to Expand Forum to Full Width