select a.*, c.name as clientTypeName from t_client a, t_code c where c.groupType='client_type' and a.clientType = c.code and a.clientType >= '20' and a.clientType <= '80' and a.clientType = #{clientType} order by name asc select a.* from t_client a where a.seq = #{seq} update t_client set name=#{name}, clientType=#{clientType}, memo=#{memo}, phone1=#{phone1}, phone2=#{phone2}, managerName=#{managerName}, updateDatetime=now() where seq=#{seq}