Chapter 11 – Join Functions
“When spider webs unite they can tie up a lion.”
- African Proverb
A Two-Table Join Using Traditional Syntax
A Join combines columns on the report from more than one table. The example above joins the Customer_Table and the Order_Table together. The most complicated part of any join is the JOIN CONDITION. The JOIN CONDITION is which Column from each table is a match. In this case, Customer_Number is a match that establishes the relationship, so this join will happen on matching Customer_Number columns.
A two-table join using Non-ANSI Syntax with Table Alias
A Join combines columns on the report from more than one table. ...