UNION할 때 테이블명 컬럼 추가

1 개요

UNION할 때 테이블명 컬럼 추가

SELECT 'customer' table_name, id, name FROM customer
UNION ALL
SELECT 'employee' table_name, id, name FROM employee

2 같이 보기

• UNION

3 참고

• http://stackoverflow.com/questions/12992315/add-field-of-table-name-to-sql-results-from-union