home *** CD-ROM | disk | FTP | other *** search
/ C Programming Starter Kit 2.0 / SamsPublishing-CProgrammingStarterKit-v2.0-Win31.iso / bde / sdkqry.pak / JOIN.SQL < prev    next >
Encoding:
Text File  |  1997-07-24  |  126 b   |  3 lines

  1. select c.name, c.city, o.'total invoice', o.'amount paid'
  2. from "cust.dbf" c, "orders.db" o
  3. where c.'cust_no' = o.'customer no'