SELECT ..... FROM a JOIN b ON (a.docid = b.docid) LEFT OUTER JOIN (a.docid = c.docid)
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.
Dig Deeper on Oracle and SQL
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.