Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Oracle & SQLServer JOIN common syntax?
Message
From
31/05/1999 20:31:22
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Client/server
Title:
Oracle & SQLServer JOIN common syntax?
Miscellaneous
Thread ID:
00224779
Message ID:
00224779
Views:
48
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
Map
View

Click here to load this message in the networking platform