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

57 votes329 views6 answers
Sql alter table
SQL
1 vote149 views1 answer
ORACLE RIGHT TWO DIGITS
SQL
0 vote143 views1 answer
Php mysqli install
SQL
0 vote158 views1 answer
Sql convert unix time to date
SQL
0 vote134 views1 answer
Postgres add prefix to primary key
SQL
1 vote136 views1 answer
How to get the date diff on once field in sql server
SQL
0 vote134 views3 answers
Postgresql grant alter table to user
SQL
0 vote134 views1 answer
Postgresql alter column nullable
SQL
0 vote141 views1 answer
Postgresql on conflict pair
SQL
17 votes173 views6 answers
Get last record in sql
SQL