Hi Mark,
Thanks for the pointer. i have tried the the way as descripbed but couldn't get it work.
I'm new to cache and using cache 4.1.1... , can you guide me a little specific where can i change the storage defination and global ref. in cache....
Thanks again for te great help.
regards, Elvin
Mark Sires wrote:
You can't cross the namespace boundary with class definitions or with SQL. What you can do is copy the class definition of Table2 from the XYZ namespace to the ABC namespace, then edit the storage definition and change all global references to use extended syntax. If Table2 is stored in the globals ^Table2D,^Table2I, and ^Table2S, then all the references to these in the storage definition should be changed to ^|"XYZ"|Table2D, ^|"XYZ"|Table2I, and ^|"XYZ"|Table2S
Mark
"elvin" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED]
Just wondering how can we join 2 separate tables that exist in different database and namespace.
Example Table1, in ABC namespace Table2, in XYZ namespace
Join Table1 with Table2 where table1.RefID = table2.refid
thanks
