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

+ Recent posts