1 2 3 4 5 6
| INSERT INTO T_DEALER ( ID_SAP, Legal_Name, Commercial_name, Street, City, Zip_Code, Country, Phone, Commercial_Email, General_Fax, Website, VAT_Registration_Number )
SELECT TEMP_DEALERS.[Bill-To_SAP_Number], TEMP_DEALERS.[Bill-To_Legal_Name], TEMP_DEALERS.[Bill-To_Commercial_Name], TEMP_DEALERS.[Bill-To_Street], TEMP_DEALERS.[Bill-To_City], TEMP_DEALERS.[Bill-To_Postal_Code], TEMP_DEALERS.[Bill-To_Country], First(TEMP_DEALERS.[Ship-to phone]) AS [PremierDeShip-TO phone], TEMP_DEALERS.General_Email, TEMP_DEALERS.General_Fax, TEMP_DEALERS.Web_Site, TEMP_DEALERS.VAT_Registration_Number
FROM TEMP_DEALERS LEFT JOIN T_DEALER ON TEMP_DEALERS.[Bill-To_SAP_Number] = T_DEALER.ID_SAP
GROUP BY TEMP_DEALERS.[Bill-To_SAP_Number], TEMP_DEALERS.[Bill-To_Legal_Name], TEMP_DEALERS.[Bill-To_Commercial_Name], TEMP_DEALERS.[Bill-To_Street], TEMP_DEALERS.[Bill-To_City], TEMP_DEALERS.[Bill-To_Postal_Code], TEMP_DEALERS.[Bill-To_Country], TEMP_DEALERS.General_Email, TEMP_DEALERS.General_Fax, TEMP_DEALERS.Web_Site, TEMP_DEALERS.VAT_Registration_Number, T_DEALER.ID_SAP
HAVING (((TEMP_DEALERS.[Bill-To_SAP_Number]) Is Not Null) AND ((T_DEALER.ID_SAP) Is Null))
ORDER BY TEMP_DEALERS.[Bill-To_SAP_Number], T_DEALER.ID_SAP; |
Partager