SELECT a.text_val as Plz,
b.text_val as Ort

	from geodb\_textdata a  

LEFT JOIN  geodb_textdata b ON  b.loc_id=21248 AND b.text_type=500100000

WHERE
a.loc_id=21248 AND a.text_type=500400000