Sarah Freitas2,469 Points
What's the difference?
SELECT * FROM Model m INNER JOIN Make k ON m.MakeID = k.MakeID; SELECT * FROM Model m, Make k WHERE m.MakeID = k.MakeID;
Steven Parker187,484 Points
The difference is the syntax itself.
The comma syntax is older (from 1989) but still supported in most SQL engines. The
JOIN keyword syntax is the current standard (since 1992).