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 vote343 views1 answer
T-SQL Alter the column data type
SQL
0 vote348 views1 answer
Duplicate value unique constraint mysql error
SQL
0 vote412 views1 answer
Mysql delete entire row on condition
SQL
5 votes350 views1 answer
Sql use database
SQL
1 vote338 views2 answers
Postgresql backup and restore globals and data
SQL
0 vote342 views1 answer
How to print records of employees hired in particular month in oracle
SQL
1 vote354 views1 answer
Select tables with name like mysql
SQL
0 vote346 views1 answer
Postgres call view
SQL
1 vote368 views1 answer
Load mysql dumb
SQL
1 vote340 views1 answer
Postgres format date in select
SQL