Join between 2 tables in 2 databases
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?