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!
03-22-2001, 01:36 PM
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.