home *** CD-ROM | disk | FTP | other *** search
/ ProfitPress Mega CDROM2 …eeware (MSDOS)(1992)(Eng) / ProfitPress-MegaCDROM2.B6I / MAGAZINE / MISC / DBMS9104.ZIP / SQL4.APR < prev    next >
Encoding:
Text File  |  1991-03-01  |  168 b   |  6 lines
  1.  
  2. SELECT customer.c#, customer.name FROM customer, invoice
  3.  WHERE customer.c# = invoice.c#
  4.    AND city IN ('London', 'Paris')
  5.    AND date BETWEEN 12/1/90 AND 12/31/90;
  6.