Multi-Table Queries
Watch the first few minutes on us! If you'd like to watch the entire video and hundreds more like it, download code samples, access offline videos and skills assessments, and use the discussion forums, log in or purchase a subscription.
Instructor
Description
This session demonstrates the options available for you to pull in data from multiple tables in your query. We will learn how to use INNER, SELF, CROSS, and OUTER joins as well as UNIONs, EXCEPT, and INTERSECT clauses.
Table of Contents
| 00:00:00 | Introduction and Agenda |
| 00:02:13 | All About Multi-Table Queries (Demo) |
| 00:02:30 | INNER Joins |
| 00:15:30 | Self Joins |
| 00:23:00 | A six-table join example |
| 00:28:14 | Pre SQL-92 join syntax |
| 00:30:32 | CROSS Joins |
| 00:32:05 | OUTER Joins |
| 00:41:54 | UNIONs |
| 00:47:29 | EXCEPT and INTERSECT |
| 00:52:32 | Summary |
Related Links
- Lesson 4 Code Samples (requires a paid subscription)
Series
This course is part of the following series: