我建议您获取不同的ID，然后在列查询中获取所需的列.

I will suggest get distinct ids and then in column query get your desired columns.

类似的东西

Select (select Fehlerpfad from FehlerCodes_akt_Liste where id=A.id ) as col1, ...
from
(
   Select distinct ids from table
   .........
) A