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

14 votes125 views4 answers
Online sql compiler
SQL
0 vote106 views1 answer
MySql Modify Increment
SQL
0 vote117 views1 answer
Sql select all records from all tables where not empty
SQL
0 vote79 views1 answer
Create bakupd database sqlserver
SQL
0 vote111 views1 answer
Fast sql column count
SQL
4 votes112 views4 answers
Start mysql
SQL
10 votes131 views6 answers
Mysql set root password
SQL
1 vote118 views1 answer
Mysql decimal allow negative values?
SQL
5 votes106 views2 answers
Mysqldump password
SQL
11 votes112 views2 answers
Having keyword sql
SQL