为什么这SQL语句提示‘语法错误’？请各位高手赐教！(50分)

M

maiqingfei

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2006-07-29

• #1

select A.Operator,b.ZB+C.WB as BZ,B.ZS+C.WS as SJ,B.ZG+C.WG as GZ,
B.ZC+C.WC AS Tc from 表1 A left OUTER join (select ZUkman,sum(BZRS) as ZB,
sum(SJYS) as ZS,sum(GZL) as ZG,Count(ZUkman) as ZC from 表2 Group By ZUkman) B
on B.ZUkman=A.Operator left OUTER join (select WUkman,sum(WBZRS) as WB,
sum(WSJRS) as WS,sum(WGZL) as WG,Count(WUkman) as WC from 表3 Group By WUkman) C on C.WUkman=A.Operator

数据库为ACCESS，将数据库改为SQL，执行正常，
请问是否ACCESS数据库不支持此SQL语句查询，
那又应怎样写查询语句能应用于ACCESS中？请各位高手赐教！

 

Z

zywcd

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2006-07-29

• #2

有的sql语句在access是不支持的。
你可以启动access新建视图，然后你使用视图里面的sql语句。

 

Y

yanzhaozhizi

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2006-07-29

• #3

ACCESS 不支持left join 语法

 

M

maiqingfei

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2006-07-29

• #4

那应该怎样写SQL语句才能达到相同的效果呢？

 

Y

yanzhaozhizi

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2006-07-29

• #5

一个SQL语句实现的方法暂时没有，可以考虑分多步查询进行实现，效率就是低了点

 

H

hityou

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2006-07-29

• #6

楼主的问题是access里面left join 不能想sqlserver里面用多个
你把后面的两个left join想法联起来就是了,为了条例清晰,你最后用视图去连接
select a.id,b.* from test1 a left outer join
(select e.id as id,e.sex,f.name,e.num*f.num from test4 e left outer join test3 f on e.id=f.id) B
on a.id=b.id
写了个个简单的例子,楼主参考一下

 

Z

zywcd

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2006-07-29

• #7

access使用　INNER JOIN。

 

M

maiqingfei

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2006-07-30

• #8

请问各位高手还有没有可行的办法?