home *** CD-ROM | disk | FTP | other *** search
/ Chip 1997 April / Chip_1997-04_cd.bin / prezent / cb / data.z / AMOUNTDU.SQL < prev    next >
Text File  |  1997-01-16  |  150b  |  5 lines
  1. select Company, Sum(ItemsTotal) - Sum(AmountPaid) as AmountDue
  2.   from customer, orders
  3.   where Customer.CustNo = Orders.CustNo
  4.   group by Company
  5.