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 Listing - Inout Blockchain AltExchanger (Crypto to crypto trading exchange platform script) Inout Blockchain AltExchanger (Crypto to crypto trading exchange platform script) - Cover Image](https://listingimages.hotscriptscontents.com/cover-image/166478/medium_fe5d46e8701a323386e74fd994dada2f.png)
![Visit Listing - Business Directory Theme (New 2022) - Download Now! Business Directory Theme (New 2022) - Download Now! - Cover Image](https://listingimages.hotscriptscontents.com/cover-image/166839/medium_6e521d59d719cf961deb4b9f0c35686c.png)