2,596
社区成员
发帖
与我相关
我的任务
分享Sybase 11.9.2创建View支持union么
我单独执行
select a.invno, a.vo_sum-isnull(b.vo_sum,0) vo_sum from view_vodb_c_export_gp a,
view_vodb_d_export_gp b where a.invno*=b.invno
union
select b.invno, isnull(a.vo_sum,0)-b.vo_sum vo_sum from view_vodb_c_export_gp a,
view_vodb_d_export_gp b where a.invno=*b.invno
可以
然后想建立一个view
create view v1
as
select a.invno, a.vo_sum-isnull(b.vo_sum,0) vo_sum from view_vodb_c_export_gp a,
view_vodb_d_export_gp b where a.invno*=b.invno
union
select b.invno, isnull(a.vo_sum,0)-b.vo_sum vo_sum from view_vodb_c_export_gp a,
view_vodb_d_export_gp b where a.invno=*b.invno
提示我
Set operators may not appear within the definition of a view.
为什么？？？
select a.invno, a.vo_sum-isnull(b.vo_sum,0) vo_sum from view_vodb_c_export_gp a,
view_vodb_d_export_gp b where a.invno*=b.invno
union
select b.invno, isnull(a.vo_sum,0)-b.vo_sum vo_sum from view_vodb_c_export_gp a,
view_vodb_d_export_gp b where a.invno=*b.invno
可以
然后想建立一个view
create view v1
as
select a.invno, a.vo_sum-isnull(b.vo_sum,0) vo_sum from view_vodb_c_export_gp a,
view_vodb_d_export_gp b where a.invno*=b.invno
union
select b.invno, isnull(a.vo_sum,0)-b.vo_sum vo_sum from view_vodb_c_export_gp a,
view_vodb_d_export_gp b where a.invno=*b.invno
提示我
Set operators may not appear within the definition of a view.
为什么？？？
...全文
请发表友善的回复…
发表回复
enhydraboy 2003-09-25
- 打赏
- 举报
3q
jakey_yang 2003-09-17
- 打赏
- 举报
不支持
zyhlhx 2003-09-17
- 打赏
- 举报
12.5 才开始支持
