voila ce que cela me marque :
SELECT DISTINCT telegestion_client.`nom` , telegestion_client.`ville` FROM telegestion_client JOIN complementaire ON telegestion_client.`nom` = complementaire.`nom` && telegestion_client.`ville` = complementaire.`ville` WHERE telegestion_client.`nom` = 'nom' AND telegestion_client.`ville` = ''
Partager