求关于ＭＹＳＱＬ的一句简单语句．．．
求关于ＭＹＳＱＬ的一句简单语句．．．
update tGroup set cID=iAutoID where iAutoID =(select max(iAutoID) from tGroup) ;

以上本来是ＭＳＳＱＬ里的正确语句，
在ＭＹＳＱＬ中运行报错？请问应该怎么写？

[解决办法]
update tGroup set cID=iAutoID where iAutoID in (select idt from (select max(iAutoID) as idt from tGroup) as t)