Skip to main content
Journey Uncommon Logo
JourneyUncommon
easySQLINNER JOINSingle-choice MCQ

What is the practical difference between INNER JOIN and listing tables comma-separated with the same condition in WHERE?

SELECT * FROM a INNER JOIN b ON a.id = b.a_id; -- vs SELECT * FROM a, b WHERE a.id = b.a_id;