0

I'm not asking here what the difference is between "JOIN" and "INNER JOIN" which mean and do the same thing in SQL Server and MySQL; what I'm trying to learn is if there is any environment, dialect, or situation where "JOIN" means something other than "INNER JOIN." The only good answer I've ever seen for why "INNER JOIN" is preferred is because it's possibly ambiguous but for that to be a true assertion there would have to be situations where "JOIN" could mean something other than "INNER JOIN."

Mike C.
  • 4,829
  • 7
  • 32
  • 38
  • Not a duplicate as that question was SQL Server specific. My question is if there is any database, dialect, or environment where "JOIN" might not mean precisely the same as "INNER JOIN" – Mike C. Oct 22 '15 at 19:42
  • @MikeC Read on, one of the answers there addresses that. –  Oct 22 '15 at 19:44
  • I would say that `INNER JOIN` => `JOIN` is just **syntactic sugar**. I don't know DB where `JOIN` means something different than `INNER JOIN`. There are of course `SELF/NATURAL/EQUI/LEFT/RIGHT/FULL/CROSS` JOIN but all of them require speciffic keyword. This is the same as `LEFT JOIN` vs `LEFT OUTER JOIN` question. – Lukasz Szozda Oct 22 '15 at 19:45
  • This is required by the SQL standard and I don't know any DBMS that would do something different for `JOIN` than for `INNER JOIN` – a_horse_with_no_name Oct 22 '15 at 20:57

0 Answers0