DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2000

    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
    Baltimore, MD USA
    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.


    - 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

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.