-
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.
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|