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!

(1) Answer

Login