💼 정보 ver1.0
UNION으로 결과 집합 조합
James Wetzel
2011. 6. 15. 00:17
728x90
반응형
구문
select_statement
UNION [ALL]
select_statement
샘플
SELECT * FROM Table1
UNION
SELECT * FROM Table2
또는
SELECT * FROM Table1
UNION ALL
SELECT * FROM Table2
select_statement
UNION [ALL]
select_statement
샘플
SELECT * FROM Table1
UNION
SELECT * FROM Table2
또는
SELECT * FROM Table1
UNION ALL
SELECT * FROM Table2
728x90
반응형