Здравствуйте. Помогите исправить после Access запрос.
SELECT Client.Passport_data, Purchase.Purchase_Id,Delivery_services.Name_services,[Shipping by air].Tracking_Number, [Shipping by air].Places_arrival, [Shipping by air].Adress
FROM (Delivery_services INNER JOIN (Client INNER JOIN Purchase ON Client.Passport_data = Purchase.[Passport data]) ON Delivery_services.Name_services = Purchase.Name_services) INNER JOIN [Shipping by air] ON Delivery_services.Name_services = [Shipping by air].Name_services;
У меня получилось такое, но Access ругается "Ошибка синтаксиса в операции JOIN "
SELECT Client.Passport_data, Purchase.Purchase_Id, Delivery_services.Name_services, [Shipping by air].Tracking_Number, [Shipping by air].Places_arrival, [Shipping by air].Adress
FROM ( Client,Delivery_services,Purchase WHERE (Client.Passport_data = Purchase.[Passport data]) WHERE Delivery_services.Name_services = Purchase.Name_services) , [Shipping by air] WHERE Delivery_services.Name_services = [Shipping by air].Name_services;
