“When spider webs unite they can tie up a lion”
- African Proverb
A two-table join using Non-ANSI Syntax
|SELECT||Customer_Table.Customer_Number, Customer_Name,Order_Number, Order_Total|
|WHERE||Customer_Table.Customer_Number = Order_Table.Customer_Number;|
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 means what Column from each table is a match. In this case, Customer_Number is a match that establishes ...