Ответ

PUPer 18.02.2004 18:58 / 18.02.2004 19:14

Работает вот такой запрос и выбирает 815 строк (неужели для этого требуется много ресурсов):

^connect[$connect_string]{
$товары[^table::sql{
	SELECT
		product.Name AS "Name",
		company.Name AS "Company",
		company.Sort,
		subgroup.Name_One,
		maingroup.Name AS "Maingroup",
		company.ID,
		subgroup.ID,
		product.ID AS "ProductID",
		product.Price
	FROM
		product,
		company,
		subgroup,
		maingroup
	WHERE
		product.Subgroup = subgroup.ID AND
		maingroup.ID = subgroup.Main_Group AND 
		company.ID = product.company
	ORDER BY
		Name_One, Sort, Company, Name
	
}]
}

---