Web Scripts @ Download FreeTrial
 / home /   |Submit Script|    |Advertise|  


Two Table Join

Two Table Join - Explains how to output data from two tables.

O.S. :

Price: Free

Filesize:

Author's Website : CodeAve.com

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.






Code 128 Barcode Font - Easily print Code128 bar codes as a font