OUTER JOIN ( LEFT , RIGHT , FULL ) > ORACLE

• 목록

① select notice.* , member.name from notice LEFT OUTER JOIN member ON member.id = notice.writer;

② select notice.* , member.name from notice RIGHT OUTER JOIN member ON member.id = notice.writer;

③ select notice.* , member.name from notice FULL OUTER JOIN member ON member.id = notice.writer;