Oracle & SQL Database( Select statements, inner and outer joins, look ups) How to write a select statement? code example
Example 1: 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;
Example 2: sql inner join
SELECT column_name(s)
FROM table1
INNER JOIN table2
ON table1.column_name = table2.column_name;