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)?
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.