Fórum Como faço para filtrar dados com sql mas sem repetir reg, ? #322354

 a:=´SELECT * from ARQ_HIST a1 WHERE PAGA is null and venc between current_date -140 and current_date -5 and not exists´;
         b:=´(select * from arq_hist a2 where paga is null and a2.inscricao = a1.inscricao and venc < current_date -140) and exists´;
         c:=´(select * from arq_nome a3 where a1.inscricao = a3.inscricao and fale is not null) and exists´;
         d:=´(select * from arq_prin a4 where a1.inscricao = a4.inscricao and telefone is not null)´;