-- Rows with ID existing in both a, b and c -- JOIN is equivalent to INNER JOIN SELECT a.ID, a.NAME, b.VALUE1, c.VALUE1 FROM table1 a JOIN table2 b ON a.ID = b.ID JOIN table3 c ON a.ID = c.ID WHERE a.ID >= 1000; -- ⇓ Test it ⇓ (Fiddle source link)
-- Rows with ID existing in both a, b and c -- JOIN is equivalent to INNER JOIN SELECT a.ID, a.NAME, b.VALUE1, c.VALUE1 FROM table1 a JOIN table2 b ON a.ID = b.ID JOIN table3 c ON a.ID = c.ID WHERE a.ID >= 1000; -- ⇓ Test it ⇓ (Fiddle source link)