那我为什么不行呢?
update tp set process = a.NS + '-' + tp.pnum + '-' + tp.name from (select max([main_size]) as NS,pnum,name from tp group by pnum,name) a,tp where a.pnum=tp.pnum and a.name=tp.name
-------------------------------
这个语法SQL20000中是正确的ACCESS要修改为:
update tb1,tb2
set tb1.fld=tb2.fld1 + tb2.fld2
where.......
那我为什么不行呢?
update tp set process = a.NS + '-' + tp.pnum + '-' + tp.name from (select max([main_size]) as NS,pnum,name from tp group by pnum,name) a,tp where a.pnum=tp.pnum and a.name=tp.name