Today I was working on a particularly complicated SQL Statement with a lot of
I found myself having to add another criterion to the ON statement of joins for
all the subqueries.
I was delighted to discover that every possible join to this table was
automatically identified by Toad Insight, and as it turns out the one I happened
to need was the first one in the list, so all I had to do was hit tab and it
wrote out the long SQL Statement for me:
Now that was a significant time saver.
Also, now that the feature seems to be back to being stable, I really do like
the enhancements such as showing the data types of the fields we’re
linking to, and things like this working as intended.