1. WHERE 서브쿼리 이용하기 INSERT INTO TABLE NAME (COL1, COL2) SELECT COL1, COL2 FROM TABLE NAME2 INSERT INTO TABLE NAME (COL1, COL2) VALUES (SELECT COL1 FROM TABLE NAME2 WHERE COL1=1), (SELECT COL2FROM TABLE NAME2 WHERE COL1=1) --INSERT INTO 함수에 SELECT를 넣어 서브쿼리이용가능 SELECT * FROM TABLE NAME WHERE COL 1 = (SELECT COL 1 = FROM TABLE NAME WHERE COL NAME = '123') SELECT * FROM TABLE NAME WHERE COL 1 IN (SEL..