update a set xueke=b.xuekeid from 表1 a left join 表2 b on a.xueke=b.xuekename
update 表一 set xueke=B.xuekeid from 表一 A, 表二 B where A.xueke=B.xuekename
update a set xueke=b.xuekeid from 表1 a left join 表2 b on a.xueke=b.xuekename
select a.id , a.xingming,a.xingbie , b.xuekeid , a.banji from a,b where a.xueke = b.xuekename
(1)左联结 SELECT A.*, B.* FROM A LEFT JOIN B ON A.FK=B.MK (2)子查询 SELECT A.*,(SLECT B.FiledX FROM B WHERE A.FK=B.MK) AS B_FiledX FROM A (3) SELECT A.*, B.* FROM A,B WHERE A.FK=B.MK 以上三种方法都行。
要以学科名称为依据,匹配替换为对应ID,语句如下: ---------------------------------------------------- UPDATE A SET A.xueke = B.xuekeid FROM B WHERE A.xueke = B.xuekename ----------------------------------------------------
from 表1 a left join 表2 b
on a.xueke=b.xuekename
update 表一 set xueke=B.xuekeid
from 表一 A,
表二 B
where A.xueke=B.xuekename
from 表1 a left join 表2 b
on a.xueke=b.xuekename
from a,b
where a.xueke = b.xuekename
(2)子查询 SELECT A.*,(SLECT B.FiledX FROM B WHERE A.FK=B.MK) AS B_FiledX FROM A
(3) SELECT A.*, B.* FROM A,B WHERE A.FK=B.MK
以上三种方法都行。
----------------------------------------------------
UPDATE A SET A.xueke = B.xuekeid
FROM B
WHERE A.xueke = B.xuekename
----------------------------------------------------