各位老师，这个语句更新的结果怎么是0个记录？谢谢

jinanshui 发布于 2021-06-17 08:41， 1420 次点击

各位老师，这个语句更新的结果怎么是0个记录？谢谢
UPDATE sd2020sj2 SET sd2020sj2.评估结果 = xkcx.评估结果 from xkcx WHERE sd2020sj2.院校 = xkcx.院校 AND sd2020sj2.院校代码 = xkcx.院校代码 AND xkcx.专业类别 $ sd2020sj2.专业类别

只有本站会员才能查看附件，请登录

3 回复

laowan0012021-06-17 09:15

AND xkcx.专业类别 $ sd2020sj2.专业类别
改成 AND alltrim(xkcx.专业类别) $ sd2020sj2.专业类别
试试

[此贴子已经被作者于2021-6-17 09:17编辑过]

sdta2021-06-17 09:16

UPDATE sd2020sj2 SET sd2020sj2.评估结果 = xkcx.评估结果 from xkcx WHERE ALLTRIM(sd2020sj2.院校) == ALLTRIM(xkcx.院校) AND ALLTRIM(sd2020sj2.院校代码) == ALLTRIM(xkcx.院校代码) AND ALLTRIM(xkcx.专业类别) $ sd2020sj2.专业类别
SELECT sd2020sj2
BROWSE FOR NOT EMPTY(评估结果)

jinanshui2021-06-17 09:33

谢谢，老师