Hi there,
I dont have a parallel version with me, but have a doubt regarding it while discussing with my friend.
Can we extract data by using single oracle stage from two different schemas using SQL statements??? Can one stage be used to connect to two schemas?
eg :
select A.id,
A.dat1,
A.dat2,
B.id,
B.dat1
from
schema1 A,
schema2 B
where
A.id=B.id
Can we do this??
Regards
connecting/extracting from multiple schemas
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 97
- Joined: Tue Feb 21, 2006 6:45 am
If yopu can execute this SQL statement with your query tool, then you can do so in PX as well.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>