#85 auto generated joins in 'where' clause

open
nobody
None
5
2012-12-13
2002-04-22
Anonymous
No

I get very frustrated with the fact that I must type
in long 'where' clauses to join tables when the
database already knows how to join the tables based on
the foreign key definitions.

It would be great if I could just type in a list of
tables in a 'from' clause and then hit a control
character that would build the 'where' clause for me
based on the foreign keys. If there are multiple
foreign keys between tables, Tora could prompt me to
identify the right one.

I know that building SQL by point-and-click could do
something similar to this, but it is very cumbersome
in my view to scroll through long lists of tables and
columns to put together a query. I would much rather
type in the essentials and let Tora assist where it
can.

Discussion