Select from different data sources on a command

I have a command on one data connection and I have to reference  a table that only exists on a different data connection for the same report.

It gives me a message for table ro view does not exist because it doesn't find that table on that connection. WHat am I doing wrong, how can I reference a field from a different data connection. I tried playing with links but it did not work. Is there a way to do select statemenets on the select expert? it doesn't have the from and where keywords...
patsylippAsked:
Who is Participating?
 
POracleConnect With a Mentor Commented:
create database link from database where you are connected to other database from where you want to access table, call it dblnk

then use,

select * from table@dblnk
0
 
mlmccCommented:
You can't.

You can try using the Select Expert by setting the fields you want to link together =
The Select Expert text is the WHERE clause for the SQL.

mlmcc
0
 
mlmccCommented:
Remember, when you are building a COMMAND, you are working within that data connection so you can only reference objects that fall within the data connection.

mlmcc
0
 
Kurt ReinhardtSr. Business Intelligence Consultant/ArchitectCommented:
Agree with comments made by both mlmcc and POracle.  If you're using a SQL Command, you are limited by the constraints of what's available through SQL and your data connection.  DB linking might be a solution.

~Kurt
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.