[ SQL ] UNION ALL 사용

Q. UNION ALL 을 사용하여 TEMP 테이블과 TCOM 테이블의 EMP_ID, SALARY, COMM 컬럼을 나타내라.

 

A.

>

SELECT EMP_ID, SALARY, 0 COMM

FROM TEMP

UNION ALL

SELECT EMP_ID, SALARY, COMM

FROM TCOM ;