|
1
2
3
4
5 |
update
t1 set
KCLX=t2.KCLX,KSFS=t2.KSFSfrom
JX_PlannedCourse t1 inner
join
JX_Course t2 on
t1.KCDM=t2.KCDMINNER
JOIN
JX_CourseType ON
t2.KCLX = JX_CourseType.KCLXWHERE
ISNULL(t1.KCLX,‘‘)=‘‘
OR
ISNULL(t1.KSFS,‘‘)=‘‘ |
原文：http://www.cnblogs.com/WuHZ/p/3527120.html