Hopefully someone can help with this I am struggling to get my head around it.

I have a table called `tblAgreements` that looks like this:

```
AgreementID | GroupDescription |   Live
------------+------------------+--------
20549       |        h&s       |    1
20549       |    construction  |    1
20549       |        HR        |    1
20549       |      Legal       |    1

```

My aim is to pull all agreement ID's that have **only** H&S and construction group descriptions. If an `agreementID` has h&s, construction as well as any other values (like in my example) - it won't be picked up. Only those that have H&S, construction or both.

My query looks like this

```
select * 
from tblagreements 
where groupdescription in ('construction', 'h&s')

```

This would bring back something similar to my example table, which isn't what I would want as there are also HR/Legal groupdescriptions for that agreementID

Does that make sense? Hopefully someone can help me get my head around this!

Thanks as always