Feature Request: "Smart" Join suggestions

swrobelswrobel Posts: 31
edited September 18, 2007 4:03PM in SQL Prompt Previous Versions
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?

Comments

  • Eddie DEddie D Posts: 1,800 Rose Gold 5
    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 Davis
    Senior Product Support Engineer
    Redgate Software Ltd
    Email: support@red-gate.com
  • Eddie DEddie D Posts: 1,800 Rose Gold 5
    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 Davis
    Senior Product Support Engineer
    Redgate Software Ltd
    Email: support@red-gate.com
Sign In or Register to comment.