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

0 vote364 views1 answer
#1231 - Variable 'sql_mode' can't be set to the value of 'NULL'
SQL
1 vote345 views1 answer
Postgres killing connections on db
SQL
0 vote320 views1 answer
Provera dupliranih konatakata
SQL
51 votes715 views6 answers
Installing mysql on ubuntu
SQL
0 vote340 views1 answer
Less than date query sqlachemy
SQL
3 votes336 views1 answer
Mssql remove column
SQL
0 vote325 views1 answer
Get created time of database psql 8
SQL
4 votes385 views1 answer
Postgres delete last row
SQL
1 vote346 views1 answer
Drush sql-dump
SQL
0 vote332 views1 answer
Drop all tables db2
SQL