select出的sum能查出来，但一直提示Order by clause 不能使用此查询类型

[蝈蝈俊]

（在sql server的views中的new views中）
sql语句：
SELECT *
FROM (SELECT companyid, SUM(point) AS cc
FROM Tproduct
GROUP BY companyid
HAVING companyid IN
(SELECT companyid
FROM Tsellcompany
WHERE agreement = '1')) a
ORDER BY cc DESC
提示
Order by clause 不能使用此查询类型
结果能出现，

在asp语句中无法运行。

[huitor]

在view的select clause中,注意:
1.不能出现ORDER BY, COMPUTE, COMPUTE BY
2.不能出现INTO
3.不能引用临时表

[008]

能说的明白一点吗？我没看懂。结果能出现是什么意思？

[tanghuan]

SELECT *
FROM (SELECT Tproduct.companyid, SUM(Tproduct.point) AS cc
FROM Tproduct,Tsellcompany
where Tproduct.companyid = Tsellcompany.companyidand
Tsellcompany.agreement = '1'
GROUP BY companyid
) a
ORDER BY cc DESC

[tanghuan]

SELECT *
FROM (SELECT Tproduct.companyid, SUM(Tproduct.point) AS cc
FROM Tproduct,Tsellcompany
where Tproduct.companyid = Tsellcompany.companyid and
Tsellcompany.agreement = '1'
GROUP BY companyid
) a
ORDER BY cc DESC

[蝈蝈俊]

不行。还是那个提示：Order by clause 不能使用此查询类型

[none]

就象HUITOR说的那样，视图里不能有ORDER BY。
要排序，应该在查询视图时加ORDER BY子句

[蝈蝈俊]

查询视图时加ORDER BY子句????
如何加？？？

[none]

select c1, c2, c3 ... from 视图 order by ci1, ci2...