Source Codes World
Back to Script

The Author of this Script has either not provided the URL for the script or the URL format is invalid. So, no website is available for further information.

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.

Two Table Join -
Disclaimer: You are watching a site outside Vyom Network. We are not affiliated with the authors of this page nor responsible for its content.