SELECT Name, addresse, plz, city FROM nav_kontakt WHERE name LIKE 'anw%'

SELECT k.Name, k.addresse, k.plz, k.city, lr.Name, an.beschreibung, _
  lr.adressformat FROM 
((nav_kontakt AS k INNER JOIN nav_kontakt_gebez AS kg ON k.Nr = kg.Kontaktnr)
INNER JOIN Nav_Laender_Regionen AS lr ON k.Laendercode = lr.Code) 
Left JOIN Nav_Anreden an ON k.Anredecode = an.Code 
WHERE k.name LIKE 'anw%' AND kg.gbcode='DEB'