List:General Discussion« Previous MessageNext Message »
From:Tom Crimmins Date:March 31 2005 4:43am
Subject:RE: What's up with this syntax?
View as plain text  
On Wednesday, March 30, 2005 22:25, Daniel Kasak wrote:

> update
>     _cached_LinesNotTolling LNT inner join TelecomLinePosting TLP
>         on LNT.Line=TLP.Line
>     inner join TelecomAccountPosting TAP
>         on TLP.TelecomLinePostingID=TAP.DanPK
>     inner join PhoneTypes
>         on TLP.LineType=PhoneTypes.ID
>     set
>         AnnualService=sum(TLP.Service)/1*12,
>         LNT.PhoneType=SitRepDesc,
>         MaxOfInvDate=InvDate
>     where
>         TAP.DanPK=41675
>     group by
>         TLP.Line
> It's giving me:
> You have an error in your SQL syntax.  Check the manual that
> corresponds to your MySQL server version for the right syntax to use
> near 'group by TLP.Line'
> Looks right to me...

Remove the group by. A group by is used to group rows returned by 
a select statement.

Tom Crimmins
Interface Specialist
Pottawattamie County, Iowa
What's up with this syntax?Daniel Kasak31 Mar
  • Re: What's up with this syntax?Rhino1 Apr
RE: What's up with this syntax?Tom Crimmins31 Mar
  • Re: What's up with this syntax?Daniel Kasak31 Mar