Toad World® Forums

Can join across SQL Server databases without forcing a "heterogeneous" qry?


#1

Hi. I have two databases on the same server and often need to join tables across the two databases. I would like to use Query Builder to do that BUT every time I do, it forces a “heterogeneous query”. Is there a way to avoid that (besides using aliases or views that “select all” from the ‘other’ database)?


#2

You would need to set up features from that database. IE: If you are using Oracle, you would need to use DBLinks. Otherwise you need to use a heterogeneous query.

Debbie