Update `buanderies` join `paiementsbobines` on Prenom = Qui set paye = TRUE WHERE Mois = 7 and MONTH(Date_paiement) > 7 and Type = 'Buanderie - Lessive' and Paiement >= (Bas + Haut) SELECT Qui,Mois,(Bas + Haut) FROM `buanderies` where (Bas+Haut) <> 0 and Paye = False order by Qui,Mois Impayés lessives
