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

 FROM [CONNECTED_TABLE_NAME]

 LEFT JOIN i21 AS omades ON [CONNECTED_TABLE_NAME].p01 = omades.nr01

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