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 vote229 views1 answer
Yesql
SQL
10 votes163 views1 answer
Oracle view dependencies
SQL
0 vote204 views1 answer
Sql server size of every table in a db
SQL
6 votes206 views2 answers
If not exists insert sql
SQL
1 vote214 views1 answer
Epoch time converter in snowflake
SQL
28 votes215 views6 answers
Mysql change user password
SQL
2 votes188 views1 answer
Convert series number to date in sql
SQL
2 votes165 views1 answer
Select sid oracle
SQL
0 vote208 views1 answer
Using GROUP BY in MySQL Join Table
SQL
9 votes195 views4 answers
How to remove duplicate in sql
SQL