I am trying to create a SQL query for access to recover data from the Internet that myodbc connection , But the time to complete the query is too long, so I think the problem is with the query: SELECT COUNT ([o]. [Order_id] ) Asmany_orders, (SELECT SUM (.. [OP1] [products_quantity]) OT1 from orders_total, as order O1, orders_products OP1 ou [O1] as a In the form [date_purchased]> date =) - 30 and [O1] [orders_id] = [OP1] [... orders_id] and [OT1]. [Orders_id] = [OP1]. [Orders_id] and [OT1 ]. [Class] = "ot_total" and [O1]. [Orders_status] = 1 and [OP1]. [Products_id] = [session]. [Products1] [products1] [product_id] group [op1]. [Products_id]) pediant, [op] . [Products_model], Goal ((7 + 1) * (howmany_orders / 90)) + 1) - (P. Stock_AL- IIF (Pendetta> 0, Pendiantie, 0)), 0) AS Peder, order_tatal AT from PR_ID, According to the order, Inner Join product as order-products at mid-end ([op]. [Products_model], 4) such as p.ref_id where [o]. [Date_purchased]> gt; Date...