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 vote117 views1 answer
Sql file in postgres with pgadmin
SQL
3 votes116 views1 answer
Mysql load sql from file
SQL
2 votes113 views1 answer
Check isolation level in mysql
SQL
17 votes116 views4 answers
Sort by mysql
SQL
1 vote123 views3 answers
Mysql disable foreign keys check
SQL
1 vote110 views3 answers
Postgresql connect to database
SQL
24 votes125 views5 answers
Import dump mysql
SQL
7 votes111 views2 answers
Add column table pl sql
SQL
0 vote108 views1 answer
Restore backup "text" postgresql command line
SQL
1 vote117 views1 answer
Oracle list constraints
SQL