Information générale
Titre:
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
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement