select * from adressen
  left join telefon
  on adressen.id = telefon.adr_id