set default join conditions
I work on the same databases on a regular basis. Many do not have foreign keys and do not used identically named column names in tables that I'm joining.
I repeatedly have to specify the same several columns in the join condition.
I'd love a way for SQLPrompt to either remember join clauses I've previously used, or allow me to specify default join conditions for pairs of tables (or both).
Anonymous
shared this idea
-
Jeremy Hodge
commented
This is a must have for me as well. I am constantly writing the same join clauses. It would be great to have a mapping (similar to the custom aliases) where you can specify the most common joins. When you attempt to join the two tables, those results should be at the top of the list. Ideally, if there are several join conditions, they would all be applied as a single suggestion.
In my situation, foreign keys typically exist and some fields are named identically, but there are so many similar column names that I usually have to scroll several pages on the suggestion list.
Additionally, when 'use ranked suggestions' is selected, the most commonly used joins should be ranked at the top. I was expecting this behavior when ranked suggestions was implemented, but it does not appear to rank joins.