i know they must exist in all the tables. to know how many times the ID is in the 5 tables i can use SELECT COUNT(*) AS nbr_doublon, champ1, champ2, champ3 FROM table GROUP BY champ1, champ2, champ3 HAVING COUNT(*) > 1 so but i lose a lot of data. i prefer use inner join but it s difficult for me:-(