3 ms·
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 i
by craigds 8y ago
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 8y agohttps://stackoverflow.com/questions/22678643/old-style-oracle-outer-join-syntax-why-locate-the-on-the-right-side-of-the 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.