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...
--
Daniel Kasak
IT Developer
NUS Consulting Group
Level 5, 77 Pacific Highway
North Sydney, NSW, Australia 2060
T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989
email: [EMAIL PROTECTED]
website: http://www.nusconsulting.com.au
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
