ALLBASE/SQL Reference Manual (36216-90216)

Chapter 3 133
SQL Queries
Complex Queries
The result of the above query follows:
SELECT PartName, PartNumber, VendorName FROM PurchDB.Parts NATURAL LEFT...
------------------------------+----------------+---------------------
PARTNAME |PARTNUMBER |VENDORNAME
------------------------------+----------------+---------------
| |Kinki Cable Co.
| |SemiTech Systems
| |Chocolate Chips
|XXXX-D-LO|
Winchester Drive |1343-D-01 |Remington Disk Drives
Winchester Drive |1343-D-01 |Morgan Electronics
Video Processor |1143-P-01 |Eve Computers
Video Processor |1143-P-01 |Coupled Systems
.
.
.