Merge Queries
Merge combines columns from two related tables using a common field.
Example:
Sales Table
|
Product ID |
Sales |
|
P101 |
50000 |
Product Table
|
Product ID |
Product |
|
P101 |
Laptop |
Merge using:
Product ID
Result:
|
Product ID |
Sales |
Product |
|
P101 |
50000 |
Laptop |
Common Join Types
- Left Outer
- Right Outer
- Full Outer
- Inner
- Left Anti
- Right Anti
Append Queries
Append stacks rows from multiple tables.
Example:
January Sales + February Sales + March Sales
becomes:
Combined Sales
Key Difference
Merge = Add columns
Append = Add rows
Practice
Merge Sales with Product Master and append January, February and March sales.