tlavelle Posted August 28, 2007 Share Posted August 28, 2007 What is wrong with this sql? use imis; select count(id) as duescount , id from activity where activity_type='dues' and duescount>=2 group by id order by duescount asc; it is giving me this Msg 207, Level 16, State 3, Line 2 Invalid column name 'duescount'. Can you not sue an alias like this? If not, how do I make that comparison? Quote Link to comment https://forums.phpfreaks.com/topic/67050-comparing-using-an-alias-and-count/ Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.