| Data block based on join, tables in different schema [message #586259] |
Wed, 05 June 2013 00:24  |
NewToOracle10g
Messages: 34
Registered: April 2009
Location: Adelaide
|
Member |
|
|
Hi
I have to create a data block which is is based on two tables. Both are in different schema.
if I create indivial data block, like select * from table1 and select * from table2, both data blocks work fine. but when I try to do
select col1, col2.... from table1, table2
where table1.colkey = table2.colkey
is it returning unable to perform query. I f I run the query forms has formed in sql it returns values.
Is there any work around to deal with this?
I have already asked about views but dba not ready to create view.
Regards,
Leena
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
