Masquer enregistrement après sélection

select terrains.* were client is null;

select * from MAISONS
WHERE N° not in (SELECT [Maison choisie] from CLIENTS); 

SELECT maison
FROM houses
WHERE houses.[maison] Not In 
(
SELECT distinct houses.maison
FROM Houses INNER JOIN Clients 
ON Houses.Maison = Clients.House
or instr(clients.house,houses.maison)>0
or instr(houses.maison,clients.house) >0 ;
)

SELECT DISTINCT houses.maison
FROM Houses INNER JOIN Clients ON Houses.Maison=Clients.House Or instr(clients.house,houses.maison)>0 Or instr(houses.maison,clients.house)>0;

SELECT maison
FROM houses
WHERE maison not in (SELECT house from CLIENTS);