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 | |
|
100026 | Music by the Numbers | 54,801.74 | |
|
100027 | Up Tempo Distributors | 166.94 | |
|
100028 | OER Music | 321.00 | |
|
100029 | Cam's Country | 42,258.87 | |
|
100030 | Swingin' Strings | 81.40 | |
|
100031 | Maritime Music | 55,969.70 | |
|
100032 | Music by the Numbers | 51,595.00 | |
|
100033 | Up Tempo Distributors | 1,237.97 | |
|
100034 | Swingin' Strings | 55,940.00 | |
|
100035 | Maritime Music | 1,900.00 | |
|
100036 | Swingin' Strings | 169.07 | |
|
100037 | The Rock Studio | 47,850.85 | |
|
100038 | Maritime Music | 3,150.60 | |
|
100041 | Maritime Music | 1,784.22 | |
|
100042 | Fruit of the Lute | 65,639.19 | |
|
100046 | Maritime Music | 2,469.38 | |
|
100048 | Maritime Music | 3,554.56 | |
|
100049 | Maritime Music | 58,081.56 | |
|
100056 | The Rock Studio | 1,469.37 | |
|
100062 | The Welsh Connection | 11.40 |
next
| This example was created using WebSmart. | ||