ALLBASE/SQL Reference Manual (36216-90216)

650 AppendixC
Sample DBEnvironment
PurchDB.OrderItems Table
PurchDB.OrderItems Table
select ordernumber,itemnumber,vendpartnumber from purchdb.orderitems;
-----------+-----------+----------------
ORDERNUMBER|ITEMNUMBER |VENDPARTNUMBER
-----------+-----------+----------------
30507| 1|2310
30507| 2|7310
30508| 1|1110
30508| 2|1115
30508| 3|1113
30508| 4|8113
30509| 1|1533
30509| 2|8113
30510| 1|1001
30510| 2|1005
30511| 1|10175
30511| 2|10675
30511| 3|10975
30512| 1|750001
30512| 2|750101
30512| 3|790115
30512| 4|790805
30513| 1|1010
30513| 2|1050
30514| 1|2310
30514| 2|7310
30515| 1|71705
30515| 2|70150
30515| 3|70250
30515| 4|70500
30515| 5|71755
30516| 1|9040
30516| 2|9050
30516| 3|9060
30516| 4|9080
30516| 5|9090
30517| 1|90015
30517| 2|90035
30517| 3|90045
30518| 1|29201
30518| 2|39201
30518| 3|49201
30518| 4|99201
30519| 1|1010
30519| 2|1050
30520| 1|9375
30520| 2|9105
30520| 3|9135
30521| 1|750001
30521| 2|770105