Donnez des noms mnémoniques ou des initiales :


FROM annonce AS A
JOIN annonce_expedition AS AE
ON AE.id_annonce = A.id_annonce
JOIN membre AS M
ON M.id_membre =...