# Re: How to select records?

Posted by Ariel-CY on March 19, 1998 at 00:46:56:

In Reply to: How to select records? posted by Candy on March 17, 1998 at 19:01:58:

: How can I select records from several tables which belongs
: to different two database(.mdb)?
: Thank you !
You can open some MDB at same time.

dim db1 as database
dim db2 as database
dim rec1 as recordset
dim rec2 as recordset

set db1=opendatabase("mydb1.mdb")
set db2=opendatabase("mydb2.mdb")
set rec1=db1.openrecordset("table1",dbopendynaset)
set rec2=db2.openrecordset("table2",dbopendynaset)

...

Follow Ups:

- 还是不行！！！！！！ Candy 02:25:01 3/19/98 (1)
  - 使用 attach table 或 OLE DB 小吴 17:10:46 3/19/98 (0)