Hi Scott thanks for your prompt reply. As the data is normalised I might have some records with the same clientid in table 1 that has a different ref. I want to exclude the client as a whole if they had a ref of 25. Example if a client 1234 has 2 entries and 1 entry was 25 I want that client ignored. So if the table had 5 entries like below only 2 will be shown.
Clientid 1234 Ref 25
Clientid 1234 Ref 22
Clientid 3456 Ref 33
Clientid 5555 Ref 25
Clientid 8899 Ref 27
I assume an idea is get all clients from table 1 that =25 and as part of the inner join ignore those ?
Thanks