home *** CD-ROM | disk | FTP | other *** search
/ ProfitPress Mega CDROM2 …eeware (MSDOS)(1992)(Eng) / ProfitPress-MegaCDROM2.B6I / MAGAZINE / MISC / DBMS9102.ZIP / GERRIT4.FEB < prev    next >
Encoding:
Text File  |  1990-12-18  |  246 b   |  10 lines
  1.  
  2. Listing 4
  3.  
  4.      SELECT pname, price, qty, customer.name 
  5.           FROM part, litem, invoice customer
  6.           WHERE part.p# = litem.p#
  7.           AND litem.i# = invoice.i#
  8.           AND invoice.c# = customer.c#
  9.           AND qty > 5;
  10.