I am not able to use DB link in my SQL command to join 2 tables from 2 different databases, due to ORACLE database version bug (which has been fixed in version 9.1 or higher). For right now, is there another way to get data from 2 different database, and fill in the 1 datagrid? I tried to create 2 datasets with seperate select statement from different database, and merge these 2 datasets. However it wouldn't do it if the linking field is not the unique key in the dataset.
For example,
Table A: id goal year
              1 10 2005
              1 15 2006
              2 10 2005
              2 20 2006
Table B: id Name
              1 A
              2 B
Since table A and B are in 2 different databases, how can I have the datagrid filled as:
              id goal year Name
              1 10 2005 A
              1 15 2006 A
              2 10 2005 B
              2 20 2006 B

Thanks!