home *** CD-ROM | disk | FTP | other *** search
/ CICA 1992 November / CICA_MS_Windows_CD-ROM_Walnut_Creek_November_1992.iso / win3 / demo / quasrsql / query11.sql < prev    next >
Encoding:
Text File  |  1991-10-26  |  88 b   |  2 lines
  1. select sname from s where exists
  2.   (select * from sp where sno = s.sno and pno = 'P2');