If I write a sql query for mysql and I just specify JOIN (no outer, inner, left, etc), what type of join does this default to?
For example:
SELECT count(*) FROM Students p JOIN Classes c ON p.studentId = c.studentId
If I write a sql query for mysql and I just specify JOIN (no outer, inner, left, etc), what type of join does this default to?
For example:
SELECT count(*) FROM Students p JOIN Classes c ON p.studentId = c.studentId
According to the MySQL manual, the word inner
(or cross
) is optional, indicating that the default is an inner join.