注册 登录
编程论坛 ACCESS论坛

[求助]改写SQL语句

txay 发布于 2006-04-27 14:58, 1636 次点击

SELECT isnull(a.cfdd,'') as 'sydw',b.mc as 'dwmc',count(*) as 'shl',sum(a.dj) as 'dj',sum(a.zzj) as 'zzj'
from a,b,c
where a.cfdd *=b.ddbh and a.sydw *=c.dwbh
group by a.cfdd,b.mc

谁帮我把这个SQL语句写成能在ACCESS数据库上查询的语句,谢谢了
1 回复
#2
jxyga1112008-06-21 09:08
就用這個啊為什麼要改寫
1