联表更新

<update id="updateStudentState">
        UPDATE te_signin_details sd
        LEFT JOIN te_sign_in si ON sd.sign_in_id = si.id
        SET
        sd.state = #{state}
        WHERE
        sd.is_delete = 0
        AND si.is_delete = 0
        AND si.state = '0'
        AND sd.student_id = #{studentId}
    </update>
    ```