Insert into + SELECT

Вторник, 12 Января 2016 г. 13:46 + в цитатник

Привет Всем !
Не могу понять в чём ошибка :

SQL = " INSERT INTO OrdersAll (AgencyId, EmployeeNo, CustomerID, CurrentShipPrice, OrderDate, OrderTime, ShipDate,  ShipDetailID , RecipientID, [Recieved?], ReceivedDate , InvoiceID , InvoiceReport , InvoicePayment, DutyFee, BoxFee, TapingFee, PackingFee, " & _
" StrappingFee, DeliveryFee, Weight  ) " & _
" SELECT Orders.AgencyId, Orders.EmployeeNo, Orders.CustomerID, Orders.CurrentShipPrice, Orders.OrderDate, Orders.OrderTime, Orders.ShipDate,   Orders.ShipDetailID , Orders.RecipientID, Orders.[Recieved?], Orders.ReceivedDate , Orders.InvoiceID , Orders.InvoiceReport , Orders.InvoicePayment, Orders.DutyFee, Orders.BoxFee, Orders.TapingFee, Orders.PackingFee, " & _
" Orders.StrappingFee, Orders.DeliveryFee, Orders.Weight  " & _
" FROM Orders  IN '" & user_file & "' LEFT JOIN OrdersAll  ON  [Orders].[AgencyId]=[OrdersAll].[AgencyId]  AND  [Orders].[AgencyId]=[OrdersAll].[AgencyId]    AND   [Orders].[EmployeeNo]=[OrdersAll].[EmployeeNo]  AND " & _
" [Orders].[CustomerID]=[OrdersAll].[CustomerID] AND [Orders].[CurrentShipPrice]=[OrdersAll].[CurrentShipPrice] AND [Orders].[OrderDate] = [OrdersAll].[OrderDate] AND   [Orders].[OrderTime]= [OrdersAll].[OrderTime]  AND " & _
" [Orders].[ShipDate] = [OrdersAll].[ShipDate] AND  [Orders].[ShipDetailID] = [OrdersAll].[ShipDetailID] AND [Orders].[RecipientID] = [OrdersAll].[RecipientID] AND [Orders].[Recieved?]=[OrdersAll].[Recieved?]  AND " & _
" [Orders].[ReceivedDate] = [OrdersAll].[ReceivedDate] AND   [Orders].[InvoiceID] = [OrdersAll].[InvoiceID] AND [Orders].[InvoiceReport]= [OrdersAll].[InvoiceReport]  AND [Orders].[InvoicePayment] = [OrdersAll].[InvoicePayment] AND " & _
" [Orders].[DutyFee]=[OrdersAll].[DutyFee] AND [Orders].[BoxFee] = [OrdersAll].[BoxFee] AND [Orders].[TapingFee]= [OrdersAll].[TapingFee]  AND [Orders].[PackingFee]= [OrdersAll].[PackingFee]  AND " & _
" [Orders].[StrappingFee]=[OrdersAll].[StrappingFee] AND [Orders].[DeliveryFee]=[OrdersAll].[DeliveryFee] AND [Orders].[Weight] = [OrdersAll].[Weight]  WHERE [Orders].[OrderId] Not IN (SELECT [OrdersAll].[OrderIdAgency] FROM [OrderIdAgency])"