1234567891011121314 |
- 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 JOIN "Vogl7x"."dbo"."BMW AH Vogl$Customer Group" T2 ON T1."Customer Group Code" = T2."Code"
|