ALLBASE/SQL Reference Manual (36216-90216)

656 AppendixC
Sample DBEnvironment
PurchDB.SupplyPrice Table
PurchDB.SupplyPrice Table
isql=> select partnumber, vendornumber,vendpartnumber from purchdb.suppl
----------------+------------+----------------
PARTNUMBER |VENDORNUMBER|VENDPARTNUMBER
----------------+------------+----------------
1123-P-01 | 9002|1110
1123-P-01 | 9003|90005
1123-P-01 | 9007|35001
1123-P-01 | 9008|750001
1123-P-01 | 9009|19101
1123-P-01 | 9012|71705
1133-P-01 | 9002|1115
1133-P-01 | 9003|90015
1133-P-01 | 9007|35011
1133-P-01 | 9009|29201
1143-P-01 | 9004|10175
1143-P-01 | 9007|35101
1143-P-01 | 9008|750101
1143-P-01 | 9009|39201
1153-P-01 | 9002|1113
1153-P-01 | 9003|90035
1153-P-01 | 9007|35201
1223-MU-01 | 9005|390121
1223-MU-01 | 9013|9102
1223-MU-01 | 9015|9010
1233-MU-01 | 9005|390221
1233-MU-01 | 9013|9115
1233-MU-01 | 9015|9020
1243-MU-01 | 9005|390321
1243-MU-01 | 9013|9375
1243-MU-01 | 9015|9030
1323-D-01 | 9004|10675
1323-D-01 | 9009|49201
1323-D-01 | 9012|70150
1323-D-01 | 9015|9040
1333-D-01 | 9004|10975
1333-D-01 | 9012|70250
1333-D-01 | 9015|9050
1343-D-01 | 9001|2310
1343-D-01 | 9011|51050
1353-D-01 | 9008|770105
1353-D-01 | 9012|70350
1353-D-01 | 9015|9060
1423-M-01 | 9006|1001
1423-M-01 | 9010|1010
1433-M-01 | 9003|90045
1433-M-01 | 9007|35801
1433-M-01 | 9010|1050
1523-K-01 | 9006|1005
1523-K-01 | 9014|13350