General information
Title:
Oracle & SQLServer JOIN common syntax?
I would like to have the same SELECT statements for both Oracle and SQLServer and still be able to use the "FROM table1 INNER JOIN table2 ON condition" syntax.
I know that both will accept the JOIN condition in the WHERE clause. But:
1. I have almost 100 SELECTs that use the INNER JOIN syntax;
2. I believe the JOIN in the FROM clause is better for readability than the JOIN in the WHERE clause.
Is there any way to do it?
I know that ODBC extended SQL provides the {oj outer-join-here} synatx for outer joins. Maybe there's something like that for inner joins?
Vlad
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only