select a.ID,b.NOM,b.PRENOM,c.LIB_BAN,a.MONTANT,a.DATSIGN,a.NUMCHQ,a.DEST from CHEQUE a,PERSONNE b,BANQUES c where a.PERSID=b.ID and a.BANQUE=c.COD_BAN and NUMBORD = 1 and a.DEST='adhésion'