ID_, MEETING_ID_, USER_ID_ select mee.* FROM biz_meeting_user mee LEFT JOIN uc_user us ON mee.USER_ID_ = us.id_ WHERE us.id_ = #{userId} SELECT MEETING_ID_ FROM biz_meeting_user where USER_ID_ = #{userId} UPDATE biz_meeting_user set SIGN_IN_STATUS_ =#{inStatus} WHERE MEETING_ID_ =#{meetingId} and USER_ID_ =#{userId} UPDATE biz_meeting_user set SIGN_OUT_STATUS_ =#{outStatus}, SIGN_IN_TYPE_ =#{type} WHERE MEETING_ID_ =#{meetingId} and USER_ID_ =#{userId}