SQL语句

表trans(transID,lastDate)
表Transdetail(transID,voidDate)

我要的效果是,当lastDate=voidDate时,UPDATE表TransDetail中的TransID跟Trans中的transID一样

---

update Transdetail as a
set TransID=(select transID from Trans where lastDate=a.voidDate)

---

update TransDetail t set t.transID=(select s.transID from trans s where s.lastDate=t.voidDate)
where t.transID in (select s.transID from trans s where s.lastDate=t.voidDate)

---

修改一下
update Transdetail as a
set TransID=(select transID from Trans where lastDate=a.voidDate)
where voidDate in (select lastDate from Trans)

---

都那么快,刷新就变了

---

逻辑有问题，如有同样的lastDate， 但不同的tranid？

---

    strSql1 = "select distinct transID,lastDate from trans"
    Set rst1 = Cn.OpenResultset(strSql1, rdOpenStatic)
    If Not rst1.EOF Then
        strSql2 = "select distinct voidDate from Transdetail"
        Set rst2 = Cn.OpenResultset(strSql2, rdOpenStatic)
        If Not rst2.EOF Then
            For i = 0 To rst.RowCount - 1
                If rst1!lastDate = rst2!voidDate Then
                    strSql3 = "UPDATE TransDetail SET transID= '" &am