DECLARE @T1 TABLE(COL1 VARCHAR(1))
DECLARE @T2 TABLE(COL2 VARCHAR(5),COL3 VARCHAR(1))
INSERT @T2 SELECT 'red','A'
UNION ALL SELECT 'red','B'
UNION ALL SELECT 'red','C'
UNION ALL SELECT 'black','A'
INSERT @T1(COL1) SELECT COL3 FROM @T2 WHERE COL2='red'
SELECT * FROM @T1