Joining Table from Different Databases in an Information Link
I have two internal databases that are set up as different data sources in Spotfire. I want to join these tables on a date field, but I'm having trouble.
I'm selecting 10 columns from database A and 1 column from database B.
It works in SQL by referring to the table in database B as table@databaseB, but I can't figure out how to build the information link to get it to do the same thing.
I created the column correctly and think I made the join right. The information link keeps identifying the secondary database as the main database with a weird query.
Any help would be appreciated, thanks!