SELECT
 [CONNECTED_TABLE_NAME].nr01 AS `Κωδικός`,
 [CONNECTED_TABLE_NAME].p00 AS `Περιγραφή`,
 oikogeneies.nr01 AS `Connection_Code`,
 CAST(CONCAT('[', oikogeneies.nr01, '] ', CAST(oikogeneies.p00 AS CHAR)) AS CHAR) AS `Ανήκει Σε`

 FROM [CONNECTED_TABLE_NAME]

 LEFT JOIN i29 AS oikogeneies ON [CONNECTED_TABLE_NAME].p01 = oikogeneies.nr01

 ORDER BY `Περιγραφή`