select '001' "c1" , T1."No_" "c2" , T1."Name" "c3" , T1."Search Name" "c4" , T1."Address Salutation Code" "c5" , T1."First Name" "c6" , 'Country Region Code' "c7" , T1."Post Code" "c8" , T1."City" "c9" , T1."E-Mail" "c10" , T2."Description" "c11" , '1' "c12" 
 from "Vogl7x"."dbo"."BMW AH Vogl$Customer" T1 LEFT OUTER JOIN "Vogl7x"."dbo"."BMW AH Vogl$Customer Group" T2 on T1."Customer Group Code" = T2."Code"
