lallalero

select h.*, t.*, lastname, firstname,o.idomi, o.omiid from tblHouses h inner join tblhousetype t on h.type=t.housetypecode
inner join tblOmi o on h.idhouse=o.idomi
where type='p' and o.DateOfLeaving is null