Hi Guys,

Thanks for the replies.

Adding the where clause below returned the correct results.

WHERE Client_Accountno is not null

Select * from Contact1

Where Company <> 'Z_CANDIDATE'

And Accountno not in (Select Distinct Client_Accountno from RSM_KPI WHERE Client_Accountno is not null)

Its still going to take some getting used to the script below not working though...

Select * from Contact1

Where Company <> 'Z_CANDIDATE'

And Accountno not in (Select Distinct Client_Accountno from RSM_KPI)