I have three tables `tblClients`, `tblClientsActivities` and `tblActivities`

`tblClients` and `tblClientsActivities` are joined together to produce Table A below

```
SELECT * from tblClientsActivities 
left join tblclients on tblClientsActivities.fk_cid=tblclients.pk_cid

PK_AID      FK_CID     FK_AID
1             4          1   
2             4          2
3             4          4
4             5          1
5             5          3
6             5          5
7             6          1
8             6          2
9             7          6
10            8          3

```

The problem is how do i remove all clients where FK\_AID <> 1