Делаю запрос - хочу отсортировать по полям вида Table1.Field1 As Table1_Field1

SELECT [OrderOffer].*, Category.Product As Product, Category.Category_Id As Category_Id, Product.Code As Product_Code, Category.Code As Category_Code, Variety.Name As Variety_Name
FROM (([OrderOffer] INNER JOIN Variety ON OrderOffer.Variety_Id = Variety.Variety_Id)
INNER JOIN Category ON Variety.Category = Category.Category_Id)
INNER JOIN Product ON Category.Product = Product.Product_Id
WHERE ([OrderOffer].[Order_id] = 12)
AND (NOT Variety.InActive)
AND (NOT Category.InActive)
ORDER BY Product_Code,Category_Code,Variety_Name

Говорит нету таких полей...

Кроме как

SELECT * FROM ( SELECT OrderOffer.*, Category.Product AS Product, Category.Category_id AS Category_Id, Product.Code AS Product_Code, Category.Code AS Category_Code, Variety.Name AS Variety_Name
FROM (Product INNER JOIN (Category INNER JOIN Variety ON Category.Category_id = Variety.Category) ON Product.Product_id = Category.Product) INNER JOIN OrderOffer ON Variety.Variety_id = OrderOffer.Variety_id
WHERE (((OrderOffer.Order_id)=12) AND ((Variety.Inactive)=False) AND ((Category.Inactive)=False)))
ORDER BY Product_Code;

Ща потестим. Надо было сразу попробовать в VFP такое тоже возможно... Order By X

Насчет Order By Table1.Field1 - так не покатит... Из за причин которые долго объяснять и они не относятся к программированию на Access.

Всем спасибо...