Join 2 tables from different Namespace

[elvin]

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