csdn

两条update 语句的区别？

update a set classKey=b.schoolClassId from Student as a ,TuitionIncome b where a.id=b.studentId update a set classKey=b.schoolClassId from Student as a left join TuitionIncome b on a.id=b.studentId ...