Databases Querying Relational Databases Joining Table Data with SQL Inner Joins

Sarah Freitas
Sarah Freitas
2,469 Points

Inner Join

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; 

1 Answer

Steven Parker
Steven Parker
187,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).