Content text 04 - Multiple Table Query.pdf
Objectives • Use joins to retrieve data from more than one table • Use the IN and EXISTS operators to query multiple tables • Use a subquery within a subquery • Use an alias
Querying Multiple Tables •Retrieve data from two or more tables: • Join tables • Use same commands as for single-table queries