RE: group by error in query

2001 10:54 To: Daniel Kirk; [EMAIL PROTECTED] Subject: Re: group by error in query On Wed, Mar 21, 2001 at 07:31:20PM +1100, Daniel Kirk wrote: > Hi, > > I've just ported from SQLServer where this query ran fine, however MySQL > gives an "invalid use of group function" er

Re: group by error in query

On Wed, Mar 21, 2001 at 07:31:20PM +1100, Daniel Kirk wrote: > Hi, > > I've just ported from SQLServer where this query ran fine, however MySQL > gives an "invalid use of group function" error. > > Any ideas? > > thx > > dan > > select us.username, us.id as userid, count(*) as tips from User

RE: group by error in query (RESEND, don't think it came through)

Hi, I've just ported from SQLServer where this query ran fine, however MySQL gives an "invalid use of group function" error. Any ideas? thx dan select us.username, us.id as userid, count(*) as tips from UserTippingInfo u, Matches m, Users us WHERE round = 23 AND us.id = u.userid AND m.match

group by error in query

Hi, I've just ported from SQLServer where this query ran fine, however MySQL gives an "invalid use of group function" error. Any ideas? thx dan select us.username, us.id as userid, count(*) as tips from UserTippingInfo u, Matches m, Users us WHERE round = 23 AND us.id = u.userid AND m.match