Is this a substitute of inner join?


#1

Inner join:

SELECT * FROM t1 JOIN t2 ON t1.t2_id = t2.id;

Hypothetical substitute:

SELECT * FROM t1,t2 WHERE t1.t2_id = t2.id;

Is there any difference between these two ways?


#2

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.