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 | |
|
100113 | Music by the Numbers | .00 | |
|
100091 | Up Tempo Distributors | .00 | |
|
200051 | Up Tempo Distributors | .00 | |
|
100092 | OER Music | .00 | |
|
100093 | Maritime Music | .00 | |
|
100062 | The Welsh Connection | 11.40 | |
|
200040 | Maritime Music | 16.96 | |
|
100063 | Music by the Numbers | 17.90 | |
|
100081 | The Rock Studio | 58.57 | |
|
200019 | OER Music | 66.08 | |
|
100030 | Swingin' Strings | 81.40 | |
|
200068 | The Welsh Connection | 91.50 | |
|
100027 | Up Tempo Distributors | 166.94 | |
|
100036 | Swingin' Strings | 169.07 | |
|
200043 | Swingin' Strings | 192.20 | |
|
100084 | Up Tempo Distributors | 239.59 | |
|
100072 | Maritime Music | 256.21 | |
|
200012 | Maritime Music | 277.69 | |
|
100069 | OER Music | 281.46 | |
|
100085 | Maritime Music | 315.72 |
next
| This example was created using WebSmart. | ||