SELECT distinct b.고_ID AS ID, '1'
INTO #base31
FROM #base1 a,
d.냠냠 b
WHERE a.ID = b.고_ID
AND b.하이 IN ('1','2','3')
SELECT distinct b.고객_ID AS ID, '1'
INTO #base32
FROM #base1 a,
d.냠냠 b
WHERE a.ID = b.고_ID
AND b.하이루 IN ('1','2','3','4','5')
CREATE TABLE aaa
INSERT INTO aaa
SELECT ID,'1' FROM #base31
UNION
SELECT ID,'1' FROM #base32
--------------------------------------------------------------------------------------
이구문 간단히 바꿀방법 없을까요? |