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"