# these queries all provide 100% the exact same result, right? SELECT * FROM t1 INNER JOIN t2 ON (t2.id = t1.id) INNER JOIN t3 ON (t3.id = t1.id) SELECT * FROM t1 INNER JOIN t2 ON (t2.id = t1.id) INNER JOIN t3 ON (t3.id = t2.id) SELECT * FROM t1 INNER JOIN t3 ON (t3.id = t1.id) INNER JOIN t2 ON (t2.id = t3.id) SELECT * FROM t1 INNER JOIN (t2, t3) ON (t2.id = t1.id AND t3.id = t1.id) SELECT * FROM t1, t2, t3 WHERE t2.id = t1.id AND t3.id = t1.id;