Two Table Join
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
License & Pricing Information
Featured Marketplace Listings
Fully responsive media grid gallery with LightBox image and video support.
Contact ‘n’ Support (CNS) is a powerful and beautiful customer support …
Professional multimedia gallery / banner rotator with custom transitions.