title: How to select members of a special kind of relationship in sql
body: <p>I have 3 table as follow :</p>
  
  <pre><code>s(s# int,sname nchar(10))
  p(p# int,pname nchar(10))
  sp(s# int,p# int)
  </code></pre>
  
  <p>table "s" is table of suppliers and "s#" is primary key of it.also table "p" is table of products and "p#" is primary key on it."s#" and "p#" are foreign key in table "sp".
  now my question is "How can I select name of suppliers from table "s" which producing all of products in table "p"...</p>