oracle语句mysql数据库名称_oracle数据库的sql语句在mySql里报错

这是 oracle数据库的sql语句。但是在mySql里就报错。 1248的错误 ，那位大大 能帮忙改下。。

select u.orderno,

u.username,

u.departmentpost,

u.position,

u.technicposition,

u.Electedtype,

u.department,

a1.tys,

a1.btys,

a1.ectys,

a1.ecbtys,

g.groupname,

g.totalno,

g.anageno,

case

when a1.tys > a1.btys then

'同意'

when a1.tys < a1.btys then

'不同意'

end as tpjg,

case

when a1.ectys > a1.ecbtys then

'同意'

when a1.ectys < a1.ecbtys then

'不同意'

end as ectpjg

from (select sum(tys) as tys,

sum(btys) as btys,

sum(ectys) as ectys,

sum(ecbtys) as ecbtys,

userid

from (select count(a.id) as tys,

0 as btys,

0 as ectys,

0 as ecbtys,

b.userinfoid as userid

from vote_pstp a, vote_userinfo b

where a.psmcid = b.userinfoid

and a.psresult = '同意'

group by b.userinfoid

union all

select 0 as tys,

count(a.id) as btys,

0 as ectys,

0 as ecbtys,

b.userinfoid as userid

from vote_pstp a, vote_userinfo b

where a.psmcid = b.userinfoid

and a.psresult = '不同意'

group by b.userinfoid

union all

select 0 as tys,

0 as btys,

count(a.id) as ectys,

0 as ecbtys,

b.userinfoid as userid

from vote_ecpstp a, vote_userinfo b

where a.psmcid = b.userinfoid

and a.psresult = '同意'

group by b.userinfoid

union all

select 0 as tys,

0 as btys,

0 as ectys,

count(a.id) as ecbtys,

b.userinfoid as userid

from vote_ecpstp a, vote_userinfo b

where a.psmcid = b.userinfoid

and a.psresult = '不同意'

group by b.userinfoid)

group by userid) a1,

vote_userinfo u,

vote_cegroup g

where a1.userid = u.userinfoid

and u.groupid = g.groupid;