Help Section
Lab #10: Outer Join Select
Learn how to write SELECT statements with a query of data derived by an outer join against an external table and internally managed tables. Reinforce how you embed the queries to use sequence values as a pseudo column before inserting the results in INSERT statements. There are three queries that you must develop and insert their data sequentially. The sequential nature of the queries resolves around the independence of the first query, and the dependencies of the second and third queries. In other words, you must insert the records into the rental table before you can insert rows in the rental_item table, and you must insert records into the rental and rental_item tables before you can insert records into the transaction table.
- Lab
- Description
- Help Section
- Instructions
Help Section
The following reading and articles are important preparation for this lab. Please make sure you read them and understand the concepts and techniques in them.
- Runtime Tables
- Mapping Joins
- Translating Joins
- Common Lookup View
WITHClause- Embedded Query
