| INNER JOIN ... ON ... in oracle ? [message #373486] |
Thu, 19 April 2001 03:43 |
Erik VAN ROY
Messages: 1
Registered: April 2001
|
Junior Member |
|
|
Somebody told me that instead of joining tables in the where-clause, it's way more performant to use the JOIN ON command.
Example : SELECT A, B FROM TableA JOIN TableB ON TableA.ID = TableB.ID
According to me this is Microsoft-SQL but it seems it really is a standard.
Anybody know something about it ?
PS. I tried it in Oracle but I get the 'SQL statement not properly ended' error.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
