Combine Two Tables
문제
코드
Oracle
SELECT firstName, lastName, city, state
FROM PERSON
LEFT JOIN ADDRESS ON PERSON.PERSONID = ADDRESS.PERSONID
SELECT firstName, lastName, city, state
FROM PERSON
LEFT JOIN ADDRESS ON PERSON.PERSONID = ADDRESS.PERSONID