SELECT employee_id, job_id, salary
FROM employees
UNION
SELECT employee_id, job_id, 0
FROM job_history;
'Oracle > SQL Fundamentals I' 카테고리의 다른 글
10일차 # 8 Manipulating Data (0) | 2012.04.17 |
---|---|
10일차 # 7-21 Controlling the Order of Rows (0) | 2012.04.17 |
10일차 # 7-19 Matching the SELECT Statements (0) | 2012.04.17 |
10일차 # 7-15: MINUS (0) | 2012.04.17 |
10일차 # 7-13: INTERSECT (0) | 2012.04.17 |