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
Softwareentwickler aus Rottweil
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