HPlogo ALLBASE/SQL Reference Manual > Appendix C Sample DBEnvironment

PurchDB.Orders Table

MPE documents

Complete PDF
Table of Contents
Index

E0300 Edition 9 ♥
E0399 Edition 8
E0897 Edition 7


 isql=> select * from purchdb.orders;
 -----------+------------+---------
 ORDERNUMBER|VENDORNUMBER|ORDERDATE
 -----------+------------+---------
       30507|        9001|19840601
       30508|        9002|19840601
       30509|        9002|19840615
       30510|        9006|19840615
       30511|        9004|19840615
       30512|        9008|19840615
       30513|        9010|19840626
       30514|        9001|19840626
       30515|        9012|19840626
       30516|        9015|19840626
       30517|        9003|19840627
       30518|        9009|19840627
       30519|        9010|19840627
       30520|        9013|19840627
       30521|        9008|19840627
       30522|        9014|19840627
       30523|        9014|19840628
 ---------------------------------------------------------------------
 Number of rows selected is 17
 U[p], d[own], l[eft], r[ight], t[op], b[ottom], pr[int] <n>, or e[nd]>




PurchDB.OrderItems Table


PurchDB.Parts Table