nakijun / txquery

Automatically exported from code.google.com/p/txquery
Other
0 stars 0 forks source link

how can i muiti table update? #22

Open GoogleCodeExporter opened 9 years ago

GoogleCodeExporter commented 9 years ago
i used 
update PICBYQDL p,DBBYQDL db Set p.YgDL=db.ygdl, p.WgDL=db.wgdl,p.glys=db.glys  
where p.Name=db.NAME;

update PICBYQDL p set p.YgDL=(select db.ygdl from DBBYQDL db where 
p.Name=db.NAME)

both error,   i search chm help file but no answer,how can i do?

Original issue reported on code.google.com by zhangron...@163.com on 14 Nov 2011 at 4:30