오라클 ansi 조인

명시적 조인

select * from aaa as A full outer join bbb as B on (A.key = B.key)

where 조건 ;

 

묵시적

select * from aaa as A, bbb as B 

where A.key = B.key

and 조건;