Comments
1 comment
-
Thanks for the feedback. SQL Prompt should defiantly only display columns from the tables in the FROM clause but there seem to be some bugs in that area atm.
In the final product we are planning to auto generate an inner join clause and use the foreign keys to generate the join condition. We are however open to suggestion about what the right thing to do and will also have an option to turn this feature.
Lionel
Add comment
Please sign in to leave a comment.
I do not like how it shows these fields as options or how it adds the table to the FROM clause w/o a join. It is like if Intellisense displayed variables that are out of scope.
How often do you have a multi-table FROM clause where a table is not part of a join? Even if Sql Prompt adds the table for you, you still need to go 'take care of it' by making the automatically added table part of a join.
It is good that they are listed first, but it makes that list long and harder to look at. It also gives you the ability to automatically generate 'bad' Sql (the table w/o the join). I think just showing the fields from the current tables is best.