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

1 vote309 views1 answer
Describe table in sql
SQL
0 vote300 views1 answer
Dapper run sql script with parameters
SQL
0 vote322 views1 answer
Laravel migration sql dump
SQL
1 vote330 views1 answer
How to get the date diff on once field in sql server
SQL
0 vote307 views4 answers
Mysql on kubernetes
SQL
0 vote293 views1 answer
Systemverilog unique constraint unique values
SQL
0 vote298 views1 answer
Conda install pymysql "windows"
SQL
0 vote310 views4 answers
How to connect form to database
SQL
0 vote291 views1 answer
Add plugins to mysql workbench
SQL
3 votes306 views2 answers
Sql asc
SQL