Contents

Combine Two Tables

   Jan 24, 2023     0 min read

Combine Two Tables

문제

175-1.jpg
175-2.jpg

코드

Oracle

SELECT firstName, lastName, city, state
FROM PERSON
    LEFT JOIN ADDRESS ON PERSON.PERSONID = ADDRESS.PERSONID

수행 결과

175result.jpg