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