Many times you will need data from more than one table to display on your report. To fetch data from two or more relational tables you will code a join.
To learn how work with joins, follow these steps:
namethat appears in both tables). I use the alias in the select list of columns and in the where clause. Furthermore, note that in the where clause I check to make sure the state abbreviation in the Cities table is equal to the state abbreviation in the States table. This is necessary so that I display the correct state name for that city. If we omit the join condition in the where clause then each city would be joined to each state, producing a much larger (and incorrect) result!