Search
 
SCRIPT & CODE EXAMPLE
 
CODE EXAMPLE FOR SQL

sql query inner join 3 tables

# 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;

 
PREVIOUS NEXT
Tagged: #sql #query #join #tables
ADD COMMENT
Topic
Name
6+7 =