select c.*, p.name as plantName from t_cs c, t_plant p where c.plantSeq = p.seq and c.csType = #{csType} and c.procStatus = #{procStatus} and c.procType = #{procType} order by c.seq desc select * from t_cs c where c.seq = #{seq} update t_cs set procStatus=#{procStatus}, updateDatetime=now() where seq=#{seq}