OpenGeoDB PLZ einem Ort zuordnen

SELECT plz.loc_id,
       plz.text_val,
       ort.text_val
FROM `geodb_textdata` AS plz
RIGHT JOIN
  (SELECT loc_id, text_val, text_type
   FROM `geodb_textdata`
   WHERE text_type = 500100000) AS ort ON plz.loc_id = ort.loc_id
WHERE plz.text_type = 500300000

Thomas Falkner