I'm having trouble coming up with a way to compare some data in SQL Server (2005). I have two tables and I need to make sure that the values from table 1 are matched in table two. Here's the table structure and some example data.

```
Table 1 
GenreId
6 

```

This is a temp table with a list of IDs that are passed in.

```
Table 2
Show| GenreId
Show1 | 2
Show1 | 6
Show2 | 6

```

This table can have many GenreIds for a show. The results that I am trying to figure out how to retrieve are that I only need shows that only have the GenreIds from table 1. So the results I expect in the end would be:

If table 1 has 6, I expect to ONLY get Show2. If table 1 has 2 and 6, then I get Show1 and Show2.

I know this is probably simple but I am really drawing a blank. Any help is very much appreciated.