home *** CD-ROM | disk | FTP | other *** search
/ Black Box 4 / BlackBox.cdr / w3_apps / winsql.arj / EXAMPLE.ZIP / QUERY11.SQL < prev    next >
Encoding:
Text File  |  1991-12-06  |  88 b   |  2 lines
  1. select sname from s where exists
  2.   (select * from sp where sno = s.sno and pno = 'P2');