Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Oracle & SQLServer JOIN common syntax?
Message
De
31/05/1999 20:31:22
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Titre:
Oracle & SQLServer JOIN common syntax?
Divers
Thread ID:
00224779
Message ID:
00224779
Vues:
47
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
Fil
Voir

Click here to load this message in the networking platform