How to make nested queries in access?

there is such a database on access with such connections
5e3ea48f613d3951142822.png
need code order to deduce the full information on customers who purchased
this wood, on the staff in charge of this vacation
wood, on the delivery of the wood;

I did 3 of the subquery, we need to combine into 1 query using sql
1 subquery [2-1]:
SELECT Orders.[Order ID], Customers.[Client Code], Customers.The Name Of The Customers.[Address], Customers.Post Clients.[Legal address], [forestry Staff].[Employee ID], [forestry Staff].Name, [forestry Staff].Name, [forestry Staff].Post, Delivery.Title, Delivery.phone, [Wood (Cimal)].[Type Code], [Wood (Cimal)].[Code Cimala]
FROM [forestry Employees] INNER JOIN (Customers INNER JOIN (((Types INNER JOIN [Wood (Cimal)] ON the Types.[Type code] = [Wood (Cimal)].[The Type code]) INNER JOIN Ordered ON [Wood (Cimal)].[Code Cimala] = Ordered.[Chimala code]) INNER JOIN (delivery INNER JOIN Orders ON delivery.[Shipping code] = Orders.[Shipping code]) ON Ordered.[Order ID] = Orders.[Order code]) ON Clients.[Client Code] = Orders.[Customer code]) ON [forestry Staff].[Employee ID] = Orders.[Code employee forestry];

2 subquery [2-2]:
SELECT [2-1].[Code Cimala] Ordered.[Code order], [2-1].[Type Code], Ordered.[Total discount], Orders.[Client code]
FROM [2-1] INNER JOIN (Booking INNER JOIN Orders ON Ordered.[Order ID] = Orders.[Order ID]) ON [2-1].[The order code] = Ordered.[Order ID];

3 subquery [2-3]:
SELECT [2-2].[Code order], [2-2].[Client code], Customers.[Client Code], Customers.The Name Of The Customers.[Address], Customers.Post Clients.[Legal address], Customers.City Clients.Index, Customers.Country
FROM [2-2] INNER JOIN Customers ON [2-2].[Customer code] = Customers.[Client Code];

Thank you in advance :)
April 7th 20 at 10:40
0 answer

Find more questions by tags SQLMicrosoft Access