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