Displaying data from more than one table
You
can include information from more than one table or view by doing
one of the following:
- Joining tables or views by a common column
- Merging data from two or more tables or views into a single
column
- Creating a subquery to retrieve data from several tables
