Feature Request: "Smart" Join suggestions

swrobel

It would be nice if the suggestion for the second term in the ON clause of a JOIN was the same as the first (if that column is available). For example, if I'm doing SELECT * FROM Customers c JOIN Orders o on c.Customer_ID = o.Customer_ID, it would be nice if when I type the "o." after the =, it would put Customer_ID at the top of the suggestion list. This makes sense, right?

Eddie D

Thank you for your suggestion.

I am sure that I have seen a similar request for this functionality.

I will check the system and if a request is not already in place I will submit this request.

Once again thank you for your suggestion.

Many Thanks
Eddie Davis

Eddie Davis
Red Gate Software Ltd
Techncial Support
E-Mail: support@red-gate.com

Eddie D

I have submitted a feature request for your suggestion.

Unfortunately it was too late to be included in SQL Prompt 3.6 released yesterday 17th September 2007.

Hopefully your suggestion will appear in a later version of SQL Prompt.

Many Thanks
Eddie

Red Gate Software Ltd
Technical Support
E-Mail: support@red-gate.com