以上好象没有DISTINCT 啊?
解决方案 »
- 更改视图是不是就是对表进行了修改了
- EXEC('select * from ' + ? )出错?
- 遇到一个问题,请大家指导一下!谢谢.救急!
- 那一种DB好,进者有份。
- 请问如何跨服务器调用自订函数??
- 大家帮忙!做不出来只好辞职了!拜托了!
- 外键和主键?
- SQL表中获取时间段里每一天的统计数据,如果表里没有这一天的记录数据就为0
- 求视图,根据用户表与年份表,统计3个工作表,得到各用户的每个年份的总工作时间,没有则为0
- OLE DB 访问接口 'MSDASQL' 返回的数据与列 '[MSDASQL].psex' 所需的数据长度不匹配
- 请问“#“的作用,高手帮助解释。
- 一个菜鸟的数据库恢复问题!急啊
SELECT
cont_bg.contno,
cont_bg.userid,
cont_bg.dpid,
cont_bg.modidate,
cont_bg.valid,
cont_bg.itemno,
cont_bg.number,
cont_bg.colnote,
cont_bg.old_value,
cont_bg.new_value
FROM cont_bg
where contno in ( select icontno from incont where preno='03FMEYS0010' union select ocontno from outcont where preno='03FMEYS0010' )
union ( SELECT
cont_bg.contno,
cont_bg.userid,
cont_bg.dpid,
cont_bg.modidate,
cont_bg.valid,
cont_bg.itemno,
cont_bg.number,
cont_bg.colnote,
cont_bg.old_value,
cont_bg.new_value
FROM cont_bg
where contno='03FMEYS0010')
cont_bg.contno,
cont_bg.userid,
cont_bg.dpid,
cont_bg.modidate,
cont_bg.valid,
cont_bg.itemno,
cont_bg.number,
cont_bg.colnote,
cont_bg.old_value,
cont_bg.new_value
FROM cont_bg
where contno in ( select icontno from incont where preno='03FMEYS0010' union select ocontno from outcont where preno='03FMEYS0010' ) or contno='03FMEYS0010'
cont_bg.contno,
cont_bg.userid,
cont_bg.dpid,
cont_bg.modidate,
cont_bg.valid,
cont_bg.itemno,
cont_bg.number,
cont_bg.colnote,
cont_bg.old_value,
cont_bg.new_value
FROM cont_bg
where contno in ( select icontno from incont where preno='03FMEYS0010' union all select ocontno from outcont where preno='03FMEYS0010' ) )
union all ( SELECT
cont_bg.contno,
cont_bg.userid,
cont_bg.dpid,
cont_bg.modidate,
cont_bg.valid,
cont_bg.itemno,
cont_bg.number,
cont_bg.colnote,
cont_bg.old_value,
cont_bg.new_value
FROM cont_bg
where contno='03FMEYS0010')