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
