"JOIN" means the same as "INNER JOIN"

Question

Possible duplicate:
Difference between JOIN and INNER JOIN

I found some legacy SQL (T-SQL) for MS SQL Server which has a suggestion

TableA JOIN TableB 

I'm just wondering if this matches up with

 TableA INNER JOIN TableB 

or if there is any difference?

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

Answer 1

Have you tried

Quote from palehorse:

They function the same. INNER JOIN may be more readable, especially if your request has other types of connections (e.g. LEFT or RIGHT) included in it.