Re: [SQL] How to use table from one database to another

2006-08-02 Thread Richard Broersma Jr
> I have 2 databases namee PAO and CAS. > PAO contains 3 schemas named Public,pao,sts CAS contains 4 schemas > named Public,cao,sts,reports > Now i am in PAO database..now i want access table 'activity' in > schema 'cas' in CAS database. > How it is posible. > 2nd thing is... > i have 2 se

[SQL] How to use table from one database to another

2006-08-02 Thread Penchalaiah P.
Hai all,  I have 2 databases namee PAO and CAS.  PAO contains 3 schemas named Public,pao,sts CAS contains 4 schemas  named Public,cao,sts,reports    Now  i am in PAO database..now i want access table 'activity' in  schema 'cas' in CAS database.  How it is posible.    2nd thing is