Is there a possiblilty of incorporating an auto table join based on the foriegn keys and columns on a table. The way i see it could work is when you have a table is your from statement could you highlight and right click on the table name and then get a list of tables that are joined to / from it. Then when you select the table the table and joins are automatically added to your query. Just an idea.

It probably could, since once the query results are displayed there is a 'linked query' button that I think does what you are asking for (though not exactly)

The Query Builder does support this though. If you add tables to your query, it will automatically create a join.

Hi, Never even thought about using query builder. Always start with a new SQL window. Cheers Mark

Wardy is right. I find it inconvenient to add tables from the left list instead of selecting a foreign key column and have a list of tables that are joined to and from it. You have all the infos in the Sql/window with the linked query button.

When are you going to add the following features:
1) handling of (left/right/inner) joins
2) handling of column aliases
3) subquery

We use left and right joins instead of (+) for more than a year making the query builder nearly useless.

It's on our to-do list.