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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]