Question

SQL语句问题，请高手帮忙，谢谢！

语句如下：
select member_id,count(oid) as totel_order,sum(order_number * order_times) as totel_number from [order] where convert(varchar(10),order_time,120) <= '2007-10-16' and convert(varchar(10),order_time,120) >= '2007-10-10' and (order_circs='已经发货' or order_circs='正在处理中') as a,(select member_id from [order] group by member_id having count(*)>1) as b where a.member_id =b.member_id
需要实现的功能是统计在一段时间内所有老客户（客户ID曾在订单表里出现过）所订有效订单（订单状态Order_circs为“已经发货”或“正在处理中”）的总数和所订商品的总数。但运行时总显示“as附近有语法错误”，请高手帮忙解决一下，不胜感激！！！！

Answer 1

from.... as a 改为：from [order] as a
from.... as b 改为：[order] as b
where...不能放在 from 和as 之间，where条件部分放到as b之后，大致如下：
select member_id,count(oid) as totel_order,sum(order_number * order_times) as totel_number from [order] as a,[order] as b
where convert(varchar(10),order_time,120) <= '2007-10-16' and convert(varchar(10),order_time,120) >= '2007-10-10' and (order_circs='已经发货' or order_circs='正在处理中').....
条件需要精简，因为没有库结构，条件不能完全帮你写好，条件中，字段名的前面要加上a.或b. 。