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 votes204 views1 answer
Laravel paginate raw sql
SQL
0 vote182 views1 answer
Mysql jdbc timezone
SQL
1 vote181 views1 answer
ERROR 1193 (HY000): Unknown system variable 'GTID_PURGED'
SQL
15 votes351 views2 answers
Sql order by alphabetical
SQL
1 vote176 views2 answers
Mysql order by date asc null last
SQL
0 vote168 views1 answer
Sub blocks in sql
SQL
0 vote194 views1 answer
Write a PL/SQL to print even numbers upto 100.
SQL
0 vote144 views1 answer
Flask_sqlalchemy install
SQL
0 vote206 views1 answer
How to remove quotes from a string in ssis load file
SQL
0 vote196 views1 answer
Get date ISO in psql
SQL