On: Say no to Venn diagrams when explaining SQL joins ...

[craigds]

Can you expand on how oracle does it?

I can't imagine any reasonable way to do outer joins in a where clause.

For inner joins the grandparent is correct and it should never matter whether you use ON or a where clause.

[barrkel → craigds]

https://stackoverflow.com/questions/22678643/old-style-oracl...

Of course it's weird and ugly. I don't think there's anything to recommend it over ANSI join syntax.