On Wednesday, March 30, 2005 22:25, Daniel Kasak wrote:
> _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
> group by
> 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.
Pottawattamie County, Iowa