Two Table Join

Visit Publisher Site
Get Two Table Join Hosting

Sponsored by TMDHosting

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.

Visit publisher site: Two Table Join

Listing Details

Filed in:
Scripts / ASP / Tutorials & Tips / Database-related
Submitted on:
Last Updated:
Jun 26, 2000 
Other listings by this publisher

License & Pricing Information

Featured Marketplace Listings

User Reviews 

Be the first to review this listing!
Average Member Rating: 2.33/5
  • Not yet reviewed by any member.... You can be the FIRST one to write a review for Two Table Join