home *** CD-ROM | disk | FTP | other *** search
/ ProfitPress Mega CDROM2 …eeware (MSDOS)(1992)(Eng) / ProfitPress-MegaCDROM2.B6I / WINDOWS / PROGRAM / WINSQL.ZIP / EXAMPLES.ZIP / QUERY11.SQL < prev    next >
Encoding:
Text File  |  1991-04-25  |  88 b   |  2 lines
  1. select sname from s where exists
  2.   (select * from sp where sno = s.sno and pno = 'P2');