Toad World® Forums

Joinig tables


#1

HI

I am new using Toad for Data Analysis,
I have two oracel connections and i want to make query based on both connection tables. I read this tutorial joint tables form different platforms, but doing this way, it makes only two query builder pages. how to made one common query builder, where i can add tables from one and the other connection?

All the best,


#2

Try this…

  1. Open the first Oracle connection in the Navigation Manager.
  2. Invoke the Query Builder via menu item or toolbar button.
  3. Select schema and table in the Object Explorer, then click and drag to the Query Builder canvas.
  4. In the Navigation Manager, double click the second Oracle connection to open it and make it the active connection.
  5. Again select the schema and table then click and drag it over to the Query Builder canvas.

At this point the Query Builder should say “Heterogeneous Query” in the background.

  1. Create a join by click and dragging one table column to the other table.
  2. Select columns to view and execute query.

Let me know if you get it to work. Thanks.


#3

Gretchen,

Start by opening the two database connections.
Open the Query Builder.
Drag the desired table from the current connection into the Query Builder.
Double click on the second connection to select.
Drag the desired table from the current connection into the Query Builder.

The background of the Query Builder will change to display “Heterogeneous Query.”

You can now join the two tables and execute.

Thanks,

Shawn…