UPDATE A SET A.IDANSID = ISNULL(B.STSID, ‘‘), A.IDUPDUSER = 2, A.DTUPDATE = CONVERT(NVARCHAR(10), GETDATE(), 111), A.TMUPDATE = CONVERT(NVARCHAR(8), GETDATE(), 108) FROM JNJT0001 A LEFT JOIN ZRECRPCWJSID B ON B.IDACCOUNT = A.IDLOGIN WHERE A.IDSYSUSER >= 1000
原文：http://www.cnblogs.com/puxian/p/5128018.html