Help Section
Lab #5: SQL Joins
Learn how to write SELECT statements that join two tables and three tables with inner and outer joins.
- Lab
- Description
- Help Section
- Instructions
Help Section
This lab relies on what you learned in the first lesson where we covered the idea of queries or SELECT statements. If you need to review this material, please use these links:
The following is an article that qualifies SQL join concepts, logic, implementation, and inheritance tree:
The following web pages explain how to write cross, inner, natural, left, right, and full joins with ANSI SQL-89 and SQL-92 syntax. They explain the concept of set theory, rules surrounding joins, and syntax examples.
You may also need to review the idea of non-equijoins, which were introduced in the WHERE Clause page. Here is a summary page on non-equijoin:
