Hi,
I have 2 differnt views v1 in one schema and v2 in another schema.
I want to combine/join these 2 views.
View v1 is in student schema.
View v2 is in information schema.
This is one schema: student
describe v1;
name varchar(300);
age number
pno number
This is another schema name: information
describe v2;
ADDRESS varchar(2000);
phone number
pno number
How can i join these 2 views on a condition based on pno?
The database is same. schema: information
How can i join 2 different views of a different schema?
Output should be.
name age ADDRESS phone # with the values (just a rough representation)
Help is very much required.
Regards
Amith