Hi All,
 
I have two databases say DB1.fdb and DB2.fdb.
 
DB1.fdb contains table "Table1" and fields like EmpCode, EmpName etc.
 
DB2.fdb contains table "Table2" and fields like EmpCode, Year, Total_Salary etc.
 
Now using these two databases and tables if i want to fetch some data like for each employee how much the total salary was for given year, then how do i get it.
 
I don't have any idea that how to get the data from two different databases using a single sql statement.
 
This is just an example i have taken.
 
Thanks in advance.
 
Vishal Tiwari


The INTERNET now has a personality. YOURS! See your Yahoo! Homepage. http://in.yahoo.com/

[Non-text portions of this message have been removed]