SELECT t_up.localizacao, Count(t_up.localizacao) AS CountOflocalizacao
FROM t_up LEFT JOIN t_registos_su ON t_up.id_up = t_registos_su.id_up
GROUP BY t_up.localizacao
HAVING (((t_up.categoria)="Cat 1" Or (t_up.categoria)="Cat 2") AND ((t_registos_su.registo) Is Null));