沈 沈前卫 Unregistered / Unconfirmed GUEST, unregistred user! 2000-04-06 #21 update还可优化，但我难得想了......,撮合用吧!
沈 沈前卫 Unregistered / Unconfirmed GUEST, unregistred user! 2000-04-06 #22 少了( update B set B.name=IsNull((select top 1 name from a where code=b.code),B.Name)
C cAkk Unregistered / Unconfirmed GUEST, unregistred user! 2000-04-06 #23 ok! gxg8816和前卫的update都通过了! 不过前卫这次慢了一点,让gxg8816抢险了.
B Big_Z Unregistered / Unconfirmed GUEST, unregistred user! 2000-04-06 #24 Update B Set B.name=(Select name From A Where A.code=B.code) Where b.code in (Select code From A)
B Big_Z Unregistered / Unconfirmed GUEST, unregistred user! 2000-04-06 #25 Faint!又错了！ Update B Set B.name=(Select Distinct name From A Where A.code=B.code) --- --------/ ! Where b.code in (Select code From A)
Faint!又错了！ Update B Set B.name=(Select Distinct name From A Where A.code=B.code) --- --------/ ! Where b.code in (Select code From A)
