OUTER JOIN ( LEFT , RIGHT , FULL )
페이지 정보
작성자 관리자 작성일 23-04-18 10:39 조회 416 댓글 0본문
① 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;
추천0 비추천 0
댓글목록 0
등록된 댓글이 없습니다.