MySQL Forums
Forum List  »  Newbie

Re: Need Help with a Select Query
Posted by: Jim Joyner
Date: May 04, 2005 02:00PM

Holy Snikes.. just found an answer, not sure if its the best way to do it or not... but it works.

Instead of doing "count(fieldname) as jcount"... I put "sum(1) as jcount" and it works wonderfully.

Thanks for anyone who looked, and I hope it helped someone down the road as well.

Jim in Montana

Options: ReplyQuote


Subject
Written By
Posted
Re: Need Help with a Select Query
May 04, 2005 02:00PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.