Retrive data from two table in two fifferent msaccess database

I have a two tables in two different MSAccess database so i want to retrive the data's from both the table by using sql query . but i do not know because the data in two database not one
Can any one help on this
please.

hussein
[256 byte] By [hussein2000] at [2007-11-20 3:01:35]
# 1 Re: Retrive data from two table in two fifferent msaccess database
And what language is doing the retrieval?
cjard at 2007-11-9 13:44:31 >
# 2 Re: Retrive data from two table in two fifferent msaccess database
YES
I AM USEING SQL STATEMENT WITH VB.NET2005

I want to retrive some fields from one table in the employee database and
other fields from other table in departement database.

thanks by
hussein2000 at 2007-11-9 13:45:31 >