Sql join 3 tables on id

-- 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)

Source: sqlfiddle.com

Similar codes

3 votes151 views4 answers
Mysql decimal
SQL
0 vote161 views1 answer
Limit in access query
SQL
0 vote103 views1 answer
'0000-00-00' for column '
SQL
0 vote208 views1 answer
Having all mysql
SQL
0 vote182 views1 answer
Sql server: concatinate column value without trailing or leading comma
SQL
0 vote168 views1 answer
Add a new column into table
SQL
7 votes166 views1 answer
Sql limit decimal places
SQL
0 vote143 views1 answer
Online sql testing tool
SQL
5 votes187 views2 answers
Functions
SQL
0 vote170 views1 answer
Mysql aspas simples
SQL