Outputting data from two tables is almost as easy as displaying from one. This example utilizes two tables with state information on them. The first table (state_order) contains state abbreviations (state), state names (statename) the year each state was admitted into the union (year) and the numeric order they entered in (entered). The second table (state_capitals) contains state abbreviations (state), state names (state) and state capitals (capital). The where statement looks to make a match on the field that each table has in common to ouput the correct capital with all the info from the state_order table.

    View Tutorial

Detailed Information      Tutorial: Two Table Join      Date Listed: 2004-01-02      Submitted By: macdonaldp      Total Hits: 1851      Rating (360 votes)

•  Comment On Tutorial

•  View Tutorial   •  Report Broken Link