select bp."VpNr", bp."PartnerName", 

       num."UploadPartnerName" as "UploadName",

       'Übernehmen' as "Auswahl",

       '---' as "Solltext",

       'Reparieren' as "Reparatur",

       'Reparaturergebnis' as "Reparaturergebnis",

       bp."VpNr" as "Partner"

  from tv_parbaduenc bp

    left join TV_NUPNAM num on num."PartnerVPNR"=bp."VpNr"

order by bp."VpNr" asc