Select rows in sql if list is a subset of another list
<p>I have two many-to-many mapping table between <code>Books-Community</code> and <code>Books-User</code>.
How can I get all the communities which ALL of it's books exist in the user's books as I pass <code>UserId</code> to the stored procedure?</p>

<p>User Books Table </p>

<pre><code>[UserId]----------------------------[BookId]

fd95eff5-394e-4d51-b1af-46723268485f----27

fd95eff5-394e-4d51-b1af-46723268485f----28

fd95eff5-394e-4d51-b1af-46723268485f----35

fd95eff5-394e-4d51-b1af-46723268485f----36

fd95eff5-394e-4d51-b1af-46723268485f----40

fd95eff5-394e-4d51-b1af-46723268485f----41

fd95eff5-394e-4d51-b1af-46723268485f----56

fd95eff5-394e-4d51-b1af-46723268485f----67

fd95eff5-394e-4d51-b1af-46723268485f----88

fd95eff5-394e-4d51-b1af-46723268485f----103

fd95eff5-394e-4d51-b1af-46723268485f----104

fd95eff5-394e-4d51-b1af-46723268485f----155

fd95eff5-394e-4d51-b1af-46723268485f----156
</code></pre>

<p>BooksCommunityMap</p>

<pre><code>[BookId]-----[CommunityId]

29-----------23

30-----------23

32-----------23

34-----------23

35-----------23

36-----------23
</code></pre>

<p>I want to select all the communities that all of it's books exists in the user's books</p>