[MS SQL/SQL Server] Select Where In select

 IN 안에 Select 구문 넣기

 SELECT * FROM tableA WHERE column1 IN ( SELECT column1 FROM tableB )