Explicit vs implicit SQL joins

231    Asked by Rama shanker in SQL Server , Asked on Mar 14, 2021

Is there any efficiency difference in an explicit vs implicit inner join? For example:

SELECT * FROM

table a INNER JOIN table b

ON a.id = b.id;

vs.

SELECT a.*, b.*

FROM table a, table b

WHERE a.id = b.id;

Answered by rhea Singh

Your Answer

Interviews

Parent Categories