0
SELECT ID, Name, Marks, Grade 
FROM Students AS s 
JOIN Grades AS g ON s.Marks BETWEEN g.Min_Mark AND g.Max_Mark;

I browsed numbers of resources about left join, right join, inner join and full outer join, but I have no idea what is this "join" means. Is this some shortcut? if not, what is this?

Thanks.

Radim Bača
  • 10,646
  • 1
  • 19
  • 33
seki
  • 89
  • 1
  • 7

1 Answers1

3

Just read the documentation from MySQL. It says.

In MySQL, JOIN, CROSS JOIN, and INNER JOIN are syntactic equivalents (they can replace each other). In standard SQL, they are not equivalent. INNER JOIN is used with an ON clause, CROSS JOIN is used otherwise.

To answer your question: join is the same like a inner join

Markus
  • 1,909
  • 4
  • 26
  • 54