【正文】
). SELECT , FROM table1, table2 WHERE (+) = 。 SELECT , FROM table1, table2 WHERE = (+)。 417 SELECT , , FROM employees e, departments d WHERE (+) = 。 Using Outer Joins … 418 Self Joins EMPLOYEES (WORKER) EMPLOYEES (MANAGER) MANAGER_ID in the WORKER table is equal to EMPLOYEE_ID in the MANAGER table. … … 419 Joining a Table to Itself SELECT || 39。 works for 39。 || FROM employees worker, employees manager WHERE = 。 … 420 Summary In this lesson, you should have learned how to use joins to display data from multiple tables in: ? Oracle proprietary syntax for versions 8i and earlier ? SQL: 1999 pliant syntax for version 9i 421 演講完畢,謝謝觀看!