这里有一条复杂的SQL86语句,谁能帮忙翻译成SQL92,立结

jsnsoft 2007-01-25 05:52:40
select apply.pk_expensecode ,apply.dmakedate,role.name,type.typename,code.expensename,
code_b.expensename expensename_b ,apply.applyname,apply.applycontent,apply.budgetmoney,apply.applymoney,
case
vbillstatus when 3 then applymoney
else 0
end,
bd_psndoc.psnname
from
clife_master_expensecode code,clife_master_expensecode code_b,
clife_expense_type type,om_role role,
clife_expense_apply apply,clife_expense_apply_b apply_b,
sm_user sm_user,sm_userandclerk,bd_psndoc
where
code.pk_expensecode=code_b.pk_father and
code.pk_expensetype=type.pk_expensetype and
code.pk_role=role.pk_role and
apply.pk_apply=apply_b.pk_apply and
(code_b.pk_expensecode=apply.pk_expensecode
or code_b.pk_expensecode in (select pk_father
from clife_master_expensecode
where apply.pk_expensecode = code.pk_expensecode))
and
sm_user.cuserid = sm_userandclerk.userid and
sm_userandclerk.pk_psndoc = bd_psndoc.pk_psndoc and
sm_user.cuserid = apply.coperatorid
order by apply.dmakedate desc
...全文
292 3 打赏 收藏 转发到动态 举报
写回复
用AI写文章
3 条回复
切换为时间正序
请发表友善的回复…
发表回复
hrb2008 2007-01-26
  • 打赏
  • 举报
回复
92标准
http://dev.mysql.com/tech-resources/crash-me.php
hrb2008 2007-01-26
  • 打赏
  • 举报
回复
select * from (
select apply.pk_expensecode ,apply.dmakedate,role.name,type.typename,code.expensename,
code_b.expensename expensename_b ,apply.applyname,apply.applycontent,apply.budgetmoney,apply.applymoney,
case
vbillstatus when 3 then applymoney
else 0
end,
bd_psndoc.psnname
from
clife_master_expensecode code
inner join clife_master_expensecode code_b
on
code.pk_expensecode=code_b.pk_father
inner join clife_expense_type type
on
code.pk_expensetype=type.pk_expensetype
inner join om_role role
on
code.pk_role=role.pk_role
inner join clife_expense_apply apply
inner join clife_expense_apply_b apply_b
on apply.pk_apply=apply_b.pk_apply
inner join sm_user sm_user
inner join sm_userandclerk
inner join bd_psndoc
where
code_b.pk_expensecode=apply.pk_expensecode
and
sm_user.cuserid = sm_userandclerk.userid and
sm_userandclerk.pk_psndoc = bd_psndoc.pk_psndoc and
sm_user.cuserid = apply.coperatorid
union all
select apply.pk_expensecode ,apply.dmakedate,role.name,type.typename,code.expensename,
code_b.expensename expensename_b ,apply.applyname,apply.applycontent,apply.budgetmoney,apply.applymoney,
case
vbillstatus when 3 then applymoney
else 0
end,
bd_psndoc.psnname
from
clife_master_expensecode code
inner join clife_master_expensecode code_b
on
code.pk_expensecode=code_b.pk_father
inner join clife_expense_type type
on
code.pk_expensetype=type.pk_expensetype
inner join om_role role
on
code.pk_role=role.pk_role
inner join clife_expense_apply apply
inner join clife_expense_apply_b apply_b
on apply.pk_apply=apply_b.pk_apply
inner join sm_user sm_user
inner join sm_userandclerk
inner join bd_psndoc
where
code_b.pk_expensecode in (select pk_father
from clife_master_expensecode
where apply.pk_expensecode = code.pk_expensecode
and
sm_user.cuserid = sm_userandclerk.userid and
sm_userandclerk.pk_psndoc = bd_psndoc.pk_psndoc and
sm_user.cuserid = apply.coperatorid)
order by dmakedate desc
--晕了
stou 2007-01-26
  • 打赏
  • 举报
回复
不是一样的用?

34,575

社区成员

发帖
与我相关
我的任务
社区描述
MS-SQL Server相关内容讨论专区
社区管理员
  • 基础类社区
  • 二月十六
  • 卖水果的net
加入社区
  • 近7日
  • 近30日
  • 至今
社区公告
暂无公告

试试用AI创作助手写篇文章吧