JOIN함수(2022.06.15)

[dept 테이블]   = LEFT 함수

[emp 테이블]  = RIGHT함수

#Left join함수

sql = """
select * from emp left join dept on emp.DEPTNO = dept.DEPTNO
"""

_db.executeAll(sql)

#Right join함수

sql = """
select * from emp right join dept on dept.DEPTNO = emp.DEPTNO
"""

_db.executeAll(sql)