VIEW

FULL OUTER JOIN 활용

 

SELECT * FROM 테이블명1 FULL OUTER JOIN 테이블명2 ON 테이블1.id=테이블2.id; 

▼

SELECT * FROM member FULL OUTER JOIN board ON member.id=board.id; 

 

OR

SELECT m.name,m.password,m.phone,m.email, b.bno,b.content, b.title, b.regdate  
FROM member m 
	FULL OUTER JOIN board b 
    			ON m.id=b.id; 

---

VIEW 생성

CREATE OR REPLACE VIEW VIEW_MEMBER_BOARD
AS
    SELECT * FROM member;

CREATE OR REPLACE VIEW VIEW_MEMBER_BOARD
AS
    SELECT m.name,m.password,m.phone,m.email, b.bno,b.content, b.title, b.regdate  
    FROM member m 
    	FULL OUTER JOIN board b 
        			ON m.id=b.id; 

---

조인한 테이블의 성명, 글제목, 작성일을 작성일 순으로  조회하기

SELECT m.name, b.title, b.regdate
FROM member m FULL OUTER JOIN board b ON m.id = b.id
WHERE m.id = 'hong'
ORDER BY b.regdate;

SELECT * FROM VIEW_MEMBER_BOARD;