home *** CD-ROM | disk | FTP | other *** search
/ QBasic & Borland Pascal & C / Delphi5.iso / C / BC_502 / 32QUERY.PAK / JOIN.SQL < prev    next >
Encoding:
Text File  |  1997-05-06  |  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'