GROUP|ORDER BY to filter by useable values rather than all

austrianfoodispuke

after GROUP BY or ORDER BY
why can't prompt show you a list of only those values which are valid?

This is especially annoying when you have to add a case statement in or are using other complex logic

Ben Pinchen

I've passed this onto the development team. Hopefully this is something that they can improve on in the future and make SQL Prompt more intelligent in this area. For your reference the feature request tracking code is: SP-1606