sql求解

[blackhero]

select top 10000 * from VIEW_ALMEVT0501 where ( evtdate>='2005-01-17' and evtdate<='2005-02-17' and ActID like '%00%' ) and actid in( select actid from view_usract where property='注册' )
union
select top 10000 * from VIEW_ALMEVT0502 where ( evtdate>='2005-01-17' and evtdate<='2005-02-17' and ActID like '%00%' ) and actid in( select actid from view_usract where property='注册' )
order by
EVTDATE desc,EVTTIME desc
这个sql语句.是两个表,我想去掉union,where后再加上AlmID=@AlmID
表VIEW_ALMEVT0501,VIEW_ALMEVT0502

Thanks

[blackhero]

自己顶一下

[hedonister]

晕，你是什么意思？要干什么？

[zhijianshadog]

楼主是不是数据库结构设计的不对，想用软件方法来实现对不对？

[dangxuehua]

select top 10000 from (
select top 10000 * from VIEW_ALMEVT0501 where ( evtdate>='2005-01-17' and evtdate<='2005-02-17' and ActID like '%00%' ) and actid in( select actid from view_usract where property='注册' )
union
select top 10000 * from VIEW_ALMEVT0502 where ( evtdate>='2005-01-17' and evtdate<='2005-02-17' and ActID like '%00%' ) and actid in( select actid from view_usract where property='注册' )
) C
where AlmID=@AlmID
order by
EVTDATE desc,EVTTIME desc

[blackhero]

select top 10000 * from (
select top 10000 * from VIEW_ALMEVT0501 where ( evtdate>='2005-01-17' and evtdate<='2005-02-17' and ActID like '%00%' ) and actid in( select actid from view_usract where property='注册' )
union
select top 10000 * from VIEW_ALMEVT0502 where ( evtdate>='2005-01-17' and evtdate<='2005-02-17' and ActID like '%00%' ) and actid in( select actid from view_usract where property='注册' )
) C
order by
EVTDATE desc,EVTTIME desc

我不加where对不对呀
-------blackhero--

[anmeier]

不加where 也对,支持dangxuehua(绿海红浪)的方法

[blackhero]

如果有四个表VIEW_ALMEVT0501,VIEW_ALMEVT0502,VIEW_ALMEVT0503,VIEW_ALMEVT0504.
每个表中的记录很多.
select top 10000 * from (select * from VIEW_ALMEVT0501 where ( evtdate>='2005-01-17' and evtdate<='2005-02-17' and ActID like '%00%' ) and actid in( select actid from view_usract where property='注册' )
union
select * from VIEW_ALMEVT0502 where ( evtdate>='2005-01-17' and evtdate<='2005-02-17' and ActID like '%00%' ) and actid in( select actid from view_usract where property='注册' )
) C
order by
EVTDATE desc,EVTTIME desc
这种方种查询的.是不是很慢.性能怎么样.

[blackhero]

自己顶一下

[amendajing]

楼主可以在查询分析起里执行sql语句，发现错误可以及时纠正