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.
This was first published in April 2006