1、CREATE TABLE TMP AS SELECT A.*【除去那个特定的FIELD】,B.FIELD FROM A, B WHERE A.IDNUM=B.IDNUM;2、UPDATE A SET FIELD=(SELECT B.FIELD FROM B WHERE A.IDNUM=B.IDNUM) WHERE A.IDNUM=B.IDNUM;
update a set colnamea in(select colnameb from b where b.idnum=a.idnum);
打错了,是应该 update a set colnamea in(select colnameb from b where b.idnum=a.idnum)
SELECT A.*【除去那个特定的FIELD】,B.FIELD FROM A, B WHERE A.IDNUM=B.IDNUM;2、UPDATE A SET FIELD=(SELECT B.FIELD FROM B WHERE A.IDNUM=B.IDNUM)
WHERE A.IDNUM=B.IDNUM;
update a set colnamea in(select colnameb from b where b.idnum=a.idnum)