我对数据库不太了解,高手帮我.

[blackhero]

(1)SELECT ACTID,EVTDATE,EVTTIME FROM VIEW_ALMEVT0412 WHERE ACTID = '000006'union SELECT ACTID,EVTDATE,EVTTIME FROM VIEW_ALMEVT0502 WHERE ACTID = '000006' order by EVTDATE
我想取前10条记录如何取
(2)
两个表的结构一样
表a, actid='000006'的记录有8条
表b, actid='000006'的记录有6条

我想查出两个表中actid='000006'的所有记录.
不用这种方法
SELECT ACTID,EVTDATE,EVTTIME FROM VIEW_ALMEVT0412 WHERE ACTID = '000006'
union
SELECT ACTID,EVTDATE,EVTTIME FROM VIEW_ALMEVT0502 WHERE ACTID = '000006'
order by EVTDATE

其它方法能不能实现.
---------blackhero-------------

[viyo]

up.

[jinger007]

SELECT ACTID,EVTDATE,EVTTIME FROM VIEW_ALMEVT0412 WHERE ACTID = '000006'union SELECT ACTID,EVTDATE,EVTTIME FROM VIEW_ALMEVT0502 WHERE ACTID = '000006' And rownum<=10 order by EVTDATE

[blackhero]

up

[flcandclf]

不大明白！

[njuzgj]

UP

[guan19801026]

兩表一樣....不是很明白
select Top t1.* from a t1,b t2 where t1.ACTID=t2.ACTID and t1.ACTID='000006'???
難道是這樣

[brightheroes]

union all
^_^

[blackhero]

两个表的结构一样
不用union all
能不能实现

[blackhero]

up