How to inner join 4 tables in sql

# no need to use parentheses - works fine
SELECT * FROM names A
INNER JOIN address B ON A.personID = B.personID
INNER JOIN emailAddress C ON A.personID = C.personID
INNER JOIN phoneNumbers D ON A.personID = D.personID;

Similar codes

6 votes249 views2 answers
Oracle compile trigger
SQL
0 vote224 views1 answer
Populate db from command line postgres
SQL
0 vote234 views1 answer
Add column in sql server ubuntu
SQL
0 vote191 views1 answer
Sql date d'aujourd'hui
SQL
6 votes215 views6 answers
Code: 'ER_NOT_SUPPORTED_AUTH_MODE', errno: 1251, sqlMessage: 'Client does not support authentication protocol requested by server; consider upgrading MySQL client', sqlState: '08004', fatal: true
SQL
0 vote214 views1 answer
On delete set default
SQL
0 vote212 views1 answer
Postgresql log
SQL
0 vote193 views1 answer
Update using case in mysql
SQL
-1 vote214 views1 answer
How to open blade file from blade in laravel
SQL
0 vote209 views1 answer
Oracle sql get value from several rows and concatenate strings
SQL