home *** CD-ROM | disk | FTP | other *** search
/ ProfitPress Mega CDROM2 …eeware (MSDOS)(1992)(Eng) / ProfitPress-MegaCDROM2.B6I / MAGAZINE / MISC / DBMS9102.ZIP / GERRIT3.FEB < prev    next >
Encoding:
Text File  |  1990-12-17  |  245 b   |  11 lines
  1. Listing 3
  2.  
  3. SELECT i#, idate FROM invoice
  4. WHERE c# IN (SELECT c# FROM customer
  5.                     WHERE name = 'Jones')
  6.  
  7. SELECT i#, idate FROM invoice
  8. WHERE c# = ANY (SELECT c# FROM customer
  9.                     WHERE name = 'Jones')
  10.  
  11.