Index
Contents
Start
End
Print
Help
8. Inner and Outer Joins
Worksheet Overview
The
select
command allows tables to be simply joined on common values and also supprt
Contents
1.
Demo: Show all Employee names with their Department location - format 1
2.
Demo: Show all Employee names with their Department location - format 2
3.
Demo: Show all Employee names with their Department location - format 3
4.
Demo: Show all Department locations with their employees
5.
Task: Show all Departments
6.
Demo: Show -ALL- Department locations with their employees
Related worksheets
1. Introduction to the Emp-dept case study
2. Some simple SQL Select statements
3. Using Functions
4. Selecting ROWS to display
5. Multiple tables
6. Summarising and Grouping
7. Handling Dates