Brandie Tarvin (11/30/2015)
Eirikur Eiriksson (11/27/2015)
Brandie Tarvin (11/27/2015)
My SO just informed me that he's learned how to write a LEFT INNER JOIN in Oracle.And now my head is just spinning with the notion that an INNER JOIN can be left or right in another SQL language. Should I be scared now?
Hint: it's Black Friday and so is the humour:-D
😎
Actually, he wasn't joking. So either he got INNER mixed up with OUTER, or there's a lot more strange going on with Oracle then I realized.
Can Oracle have left / right INNER JOINs?
By definition, there can't be a left/right inner join.
My guess is that he got confused similar to some interviewees I had who said that there were 5 different kind of joins: join, inner join, outer join, left join and right join (no full nor cross).