 |
Categories |
|
 |
|
| Two Table Join
|
Hits: 1908
|
|
Description: 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.
|
| Resource Specification |
| Date Added: |
Jun 26, 2000 |
| Last Updated: |
Jun 26, 2000 |
Average Visitor Rating:
2.75 (out of 5)
Number of Ratings: 4 Votes |
| Visitor ratings breakdown by period |
| Last 7 Days |
0 |
0 |
0 |
0 |
0 |
0.00 |
| Last Month |
0 |
0 |
0 |
0 |
0 |
0.00 |
| Last Year |
0 |
0 |
0 |
0 |
0 |
0.00 |
| Overall |
2 |
0 |
0 |
1 |
1 |
2.75 |
| |
1 |
2 |
3 |
4 |
5 |
AVG |
|
|
|
| Visitor Rating Totals |
|
|
|
|
|
| 1 |
2 |
3 |
4 |
5 |
|
|
|
|
|
Average Member Rating:
Not yet reviewed by any member....
You can be the FIRST one to write a review for
Two Table Join.
|
| Other Links by This Member |
|
|
|
|
Notes
