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

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

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

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(评估结果)

谢谢，老师