a guest Aug 17th, 2019 71 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
- 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
RAW Paste Data