SQL Append criteria

I need to know where Xy Street can be found and I have 3 tables.

select t.nev
    from hospital.person sz, hospital.place t, hospital.member ti
where 1=1
    and sz.residence_placeid=t.placeid
    and sz.residence_placeid=ti.placeid
    and t.placeid=ti.placeid
    and t.street like 'Xy Street %'
order by t.street

Addresses can also be found in table sz and ti. My question is how to append those to the criteria (like union or something like that)