How can we help you today? How can we help you today?

Feature Request: "Smart" Join suggestions

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?
swrobel
0

Comments

2 comments

Sort by
  • 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
    0
  • 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
    Eddie D
    0

Add comment

Please sign in to leave a comment.