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!