pyrebot

Better not to ignore the past but learn from it instead. Otherwise, history has a way of repeating itself.

博客园 首页 新随笔 联系 订阅 管理
1 update tabA
2 set PrintTag=c.dp_state
3 from tabA a
4 inner join tabB b on a.Code=b.design
5 inner join tabC c on b.spdm=c.sp
6 where a.PrintTag is null and c.state='已打印'

 

posted on 2014-04-15 10:56  pyrebot  阅读(220)  评论(0编辑  收藏  举报