What is the equivalent Oracle syntax of the following SQL:1999 syntax?
SELECT .....
FROM a JOIN b ON (a.docid = b.docid)
LEFT OUTER JOIN (a.docid = c.docid)
Requires Free Membership to View
The above does not look like SQL-99 compliant syntax to me. It should be as follows:
SELECT .... FROM a LEFT OUT JOIN b ON (a.docid = b.docid)And Oracle supports this. In your example, you define the join condition twice. SQL-99 does not ask you to define the join condition more than once.
This was first published in April 2006
Join the conversationComment
Share
Comments
Results
Contribute to the conversation