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