update_post_date.sql

来自「工厂采购系统,DELPHI+SQL SERVER,三层技术」· SQL 代码 · 共 9 行

update ord_mst 
	  set  last_up = b.created_dt,
	       post_date = b.created_dt,
	       rev_date = b.created_dt,
	       signatured_dt = b.created_dt,
	       confirmed_dt = b.created_dt
from ord_mst a,ord_item b where a.pono = b.pono
and   a.last_up>'2004-01-01'
 and b.itemseq = 1