Mysql 테이블 조인 쿼리

 

SELECT a.col1, a.col2, a.col3, ... FROM tableA a  LEFT JOIN tableB b on a.key = b.key

 

 

SELECT a.col1, a.col2, a.col3, ... FROM tableA a  RIGHTJOIN tableB b on a.key = b.key

 

 

SELECT a.col1, a.col2, a.col3, ... FROM tableA a  INNER JOIN tableB b on a.key = b.key

 

SELECT a.col1, a.col2, a.col3, ... FROM tableA a  LEFT JOIN tableB b on a.key = b.key WHERE b.key IS NULL

 

 

SELECT a.col1, a.col2, a.col3, ... FROM tableA a  RIGHT JOIN tableB b on a.key = b.key WHERE a.key IS NULL

 

 

SELECT a.col1, a.col2, a.col3, ... FROM tableA a  FULL OUTER JOIN tableB b on a.key = b.key

 

 

SELECT a.col1, a.col2, a.col3, ... FROM tableA a  FULL OUTER JOIN tableB b on a.key = b.key

WHERE a.key IS NULL OR b.key IS NULL