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 vote216 views1 answer
Oracle archivelog usage
SQL
19 votes218 views4 answers
Rename database in sql
SQL
0 vote233 views1 answer
Create table split string function in sql server
SQL
-1 vote229 views1 answer
Extract Data from SQL Server into XML Format
SQL
1 vote219 views1 answer
Sql order by timestamp
SQL
3 votes229 views1 answer
Sql print all names that start with a given letter
SQL
0 vote214 views1 answer
Postgresql where clause not working
SQL
0 vote226 views1 answer
Mariadb current date plus 1 day
SQL
2 votes200 views3 answers
How to get second highest salary in each department in sql
SQL
0 vote202 views1 answer
How to to get current date and time in sql
SQL