Hi,

This query does not return any results where it should.

select cl.*
from izalert_clientstatus cl 
where cl.hostname not in (
	select WSidentifier from prod_U_PV_PClist
) 

This query is more or less equivalent to the one above but does return 28 results.

select cl.hostname
from izalert_clientstatus cl
left join prod_U_PV_PClist pl on cl.hostname = pl.WSidentifier
where pl.WSidentifier is null

hostname and wsidentifier are both String fields. In the clientstatus table it has a length of 255, in the other table 63. The values for hostname and wsidentifier are e.g. 'COSARA4' and 'PC-10360'