I'm a SQL newbie and I've run into a problem that I'm not sure how to solve. I have a table of Sites, and each Site has a number of associated Reports in their own table. One field of the Report table is the answer to a Yes/No question.

I want to identify Sites that have on No's for answers in their Report.

```
SELECT * FROM Sites
INNER JOIN Reports ON Sites.ID = Reports.ID
WHERE Reports.Answer = 'No'

```

Of course this will identify all of the reports with an answer of No, but I don't want to include any Site that has a Yes on any Report.