Adding a second file with SQL
| Description: | This demonstration shows how you can add a second file to your SQL applications. By using an SQL logical join combining fields from both files, you can grab all the relevant information which will make sure your applications are as easy to use as possible. In this example, we are displaying the customer name instead of the number which helps the user choose the appropriate record. |
Click here to view step by step instructions on how this program was created
prev| Actions | Order Number | Customer Name | Total | |
|
100029 | Cam's Country | 42,258.87 | |
|
100080 | Cam's Country | 49,378.39 | |
|
100087 | Cam's Country | 571.00 | |
|
100095 | Cam's Country | 517.15 | |
|
100102 | Cam's Country | 58,618.02 | |
|
100110 | Cam's Country | 81,769.95 | |
|
100117 | Cam's Country | 1,167.00 | |
|
200014 | Cam's Country | 657.10 | |
|
200022 | Cam's Country | 1,291.90 | |
|
200055 | Cam's Country | 106,721.50 | |
|
200066 | Cam's Country | 778.00 | |
|
200076 | Cam's Country | 59,522.55 | |
|
100042 | Fruit of the Lute | 65,639.19 | |
|
200084 | Fruit of the Lute | 34,012.34 | |
|
200085 | Fruit of the Lute | 30,777.88 | |
|
100031 | Maritime Music | 55,969.70 | |
|
100035 | Maritime Music | 1,900.00 | |
|
100038 | Maritime Music | 3,150.60 | |
|
100041 | Maritime Music | 1,784.22 | |
|
100046 | Maritime Music | 2,469.38 |
next
| This example was created using WebSmart. | ||