SELECT from multiple schema's

[mrdwyer500]

How do I select/insert/update/delete from multiple schema's.
Tried:
SELECT * FROM schema1.table1, schema2.table2
WHERE schema1.table1.column1 = schema2.table2.column2;

Errored......

[saravanankm]

Hi!

Select Column1,Column2,Column3....Column(n) from
schema1.table1 a,schema2.table1 b
Where Condition


Try Type Sample Qury For This

SELECT a.brok_method, a.cust_set, a.demat_net, a.description,
b.institution_type, b.physical_net, b.TYPE
FROM fopcm.client_type a, pbrms.client_type b
WHERE a.brok_method = b.brok_method
and a.cust_set=b.cust_set
and a.demat_net=b.demat_net;


By
Captain