ASA Getting Started
Selecting Data from Multiple Tables
Introduction
| If you want to know... | Then see... |
|---|---|
| How to display a list of tables | Displaying a list of tables |
| How to display all combinations of data from two tables | Joining tables using the cross product |
| How to make a join useful | Using the ON phrase to restrict a join |
| How to join two tables in which the join's foreign keys have the same name | Joining tables using key joins |
| How to join tables on columns with the same names | Joining tables using natural joins |