Join between 2 tables in 2 databases

Hi,

I have 2 Database(s) in Sybase. Say, DB1 and DB2. I have created Datasources for these 2 Databases.

DB1 has a table called T1 and DB2 has a table called T2.

I want few columns from both the tables T1 and T2.

Can I create a join between the 2 tables which are in 2 different database(s). I created a join in the Information Desinger and added to the Information Link.

When I OpenData from Information link, the IL fails to load.

Is join across tables across 2 databases is not allowed? Can some one please advice?

Thank you

(13) Answers

Login