Solved

Select from different data sources on a command

Posted on 2011-03-17
4
382 Views
Last Modified: 2012-05-11
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...
0
Comment
Question by:patsylipp
  • 2
4 Comments
 
LVL 100

Expert Comment

by:mlmcc
ID: 35162325
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
 
LVL 100

Expert Comment

by:mlmcc
ID: 35162329
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
 
LVL 8

Accepted Solution

by:
POracle earned 500 total points
ID: 35164153
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
 
LVL 26

Expert Comment

by:Kurt Reinhardt
ID: 35166964
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

Featured Post

How to improve team productivity

Quip adds documents, spreadsheets, and tasklists to your Slack experience
- Elevate ideas to Quip docs
- Share Quip docs in Slack
- Get notified of changes to your docs
- Available on iOS/Android/Desktop/Web
- Online/Offline

Join & Write a Comment

Truncate is a DDL Command where as Delete is a DML Command. Both will delete data from table, but what is the difference between these below statements truncate table <table_name> ?? delete from <table_name> ?? The first command cannot be …
Working with Network Access Control Lists in Oracle 11g (part 2) Part 1: http://www.e-e.com/A_8429.html Previously, I introduced the basics of network ACL's including how to create, delete and modify entries to allow and deny access.  For many…
This video shows how to recover a database from a user managed backup
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.

707 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now