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

2 votes307 views3 answers
Sql function
SQL
0 vote332 views1 answer
Pl sql join 3 tables
SQL
5 votes283 views3 answers
How to remove unique key constraint in mysql
SQL
0 vote299 views1 answer
Sql date between one week
SQL
0 vote274 views1 answer
Mysql into outfile with headers
SQL
0 vote287 views2 answers
Nested query
SQL
3 votes296 views2 answers
Install mysql powershell
SQL
0 vote293 views1 answer
Add multiple field in table sql
SQL
2 votes296 views1 answer
When matched in sql server
SQL
0 vote271 views2 answers
Mysql get routine parameter list
SQL