dKunde.sql 402 B

1234567891011121314
  1. SELECT '001' "c1",
  2. T1."No_" "c2",
  3. T1."Name" "c3",
  4. T1."Search Name" "c4",
  5. T1."Address Salutation Code" "c5",
  6. T1."First Name" "c6",
  7. 'Country Region Code' "c7",
  8. T1."Post Code" "c8",
  9. T1."City" "c9",
  10. T1."E-Mail" "c10",
  11. T2."Description" "c11",
  12. '1' "c12"
  13. FROM "Vogl7x"."dbo"."BMW AH Vogl$Customer" T1
  14. LEFT JOIN "Vogl7x"."dbo"."BMW AH Vogl$Customer Group" T2 ON T1."Customer Group Code" = T2."Code"