L liaowang Unregistered / Unconfirmed GUEST, unregistred user! 2005-11-29 #1 两个access中各有一张表，两张表结构完全相同，现要跨库查询，从这两张表中各取n条记录合并在一个RecordSet里，需要怎么做？
L liaowang Unregistered / Unconfirmed GUEST, unregistred user! 2005-11-29 #2 两个access中各有一张表，两张表结构完全相同，现要跨库查询，从这两张表中各取n条记录合并在一个RecordSet里，需要怎么做？
K kgm Unregistered / Unconfirmed GUEST, unregistred user! 2005-11-29 #5 insert into RecordSetFinal select * from Rs1 where ... insert into RecordSetFinal select * from Rs2 where ...
insert into RecordSetFinal select * from Rs1 where ... insert into RecordSetFinal select * from Rs2 where ...
B bbscom Unregistered / Unconfirmed GUEST, unregistred user! 2005-11-29 #6 select * from tablename1 where fields=... UNION select * from tablename2 where fields=...
X xmg518 Unregistered / Unconfirmed GUEST, unregistred user! 2005-11-29 #8 select tablename1.Filedname,tablename2.Filedname from tablename1 inner jion tablename2 on 條件﹗
