Hi,

Is there any way to create a query that joins two tables
that reside in two different databases?

I use one database to collect raw data and another to store
processed data (resulted from processing the raw data). As
the raw data is pretty big and is only used for the initial
processing, it would help to keep them in a separate
database.

Thanks.

Hi Irving,

Yes - to do this, you need to create a "remote server" and a "proxy
table": http://dcx.sybase.com/index.php#1101...-accessrd.html

There should be simple examples of how to do this in the help. Please
let us know if you need additional assistance setting this up.

Regards,

On 12/24/2009 2:24 PM, Irving Zhu wrote:
--
Jeff Albion, Sybase iAnywhere

iAnywhere Developer Community :
http://www.sybase.com/developer/libr...ere-techcorner
iAnywhere Documentation : http://www.ianywhere.com/developer/product_manuals
SQL Anywhere Patches and EBFs :
http://downloads.sybase.com/swd/summ...&timeframe =0
Report a Bug/Open a Case : http://case-express.sybase.com/cx/