Does "JOIN" mean the same as "INNER JOIN"

Question

Possible Duplicate:
Difference between JOIN and INNER JOIN

I have found some legacy SQL (T-SQL) for MS SQL Server, which has a clause

TableA JOIN TableB

I was just wondering if this is identical to

TableA INNER JOIN TableB

or if there is any difference?

Also, if I were to port this to another database engine, e.g. MySQL, Access, Oracle, would JOIN also always mean the same as INNER JOIN?

You can lookup the following question http://stackoverflow.com/questions/565620/difference-between-join-and-inner-join — Chetter Hummin, Mar 07 '12 at 10:18
It was already asked here: http://stackoverflow.com/questions/565620/difference-between-join-and-inner-join — Tschareck, Mar 07 '12 at 10:19
Access requires the `INNER` qualifier, I believe the others you mention do not. — onedaywhen, Mar 07 '12 at 10:28

score 16 · Accepted Answer · answered Mar 07 '12 at 10:19

16

Did you try it?

Quoted from palehorse:

They function the same. INNER JOIN can be a bit more clear to read, especially if your query has other join types (e.g. LEFT or RIGHT) included in it.

answered Mar 07 '12 at 10:19

John Woo

258,903
69
498
492

7

I did try it, but just wanted to be sure there were no edge cases in which they might differ. Also apologies for asking a duplicate question. – Stephen Holt Mar 07 '12 at 10:24

Does "JOIN" mean the same as "INNER JOIN"

1 Answers1