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.
Auto join function - New feature
- Thread starter wardy
- Start date
ScottMattes
Member³
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.
Jean-Paul Finne
Member²
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.
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.
Similar threads
- Discussion
