请教:数据窗口的语法为什么不对?
以下是我建数据窗口的语法,帮忙看看。
SELECT client.c_name,
huikuan.c_name,
sum(HUIKUAN.HK_MONEY) as hk_allmoney ,
sale.c_name,
sum(SALE.S_PRICE*SALE.S_QUANTITY) as s_allmoney,
th.c_name,
sum(TH.TH_PRICE*TH.TH_SL) as th_allmoney
FROM client,
HUIKUAN group by huikuan.c_name,
SALE group by sale.c_name,
TH group by th.c_name
请各位老师和朋友不吝赐教!谢谢!