select concat(NOM,' ',PRENOM) from PERSONNE
where CPTID not in (select ID from CPTCOOP where ID in (select CPTID from PERSONNE where ID in (select PERSID from CHEQUE where DEST = 'adhésion')))
order by NOM,PRENOM