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