update where select
(MS SQL Server)语句:update bset ClientName = a.name from a,b where a.id = b.id(Oralce)语句:update bset (ClientName) =(SELECT name FROM a WHERE b.id = a.id)
(MySQL)语句:: UPDATE A, B SET A1 = B1, A2 = B2, A3 = B3 WHERE A.ID = B.ID
页:
[1]