yzmyjXcx9606163(提问者)select rg.registration_number,
rg.examiner_name,
case rg.examiner_gender when \'0\' then \'男\' else \'女\' end as 性别,
rg.examiner_tel,
rg.create_time,
GROUP_CONCAT(rgi.item_name) as item_name
from circuit_checkin_registration_info rg
inner join circuit_checkin_registration_checkitem_info rgi
on rg.institution_number=rgi.institution_number and rg.registration_number=rgi.registration_number
where rg.institution_number=\'37070201\' and rg.invalid=0
and rgi.execute_status is not null and rgi.execute_status=3
GROUP BY rg.registration_number
yzmyjXcx9606163(提问者) 回复 Z4u3z1盲猜一手是那个case出了问题,因为我删掉后就可以正常执行。
select rg.registration_number,
rg.examiner_name,
rg.examiner_gender,
rg.examiner_tel,
rg.create_time,
GROUP_CONCAT(rgi.item_name) as item_name
from circuit_checkin_registration_info rg
inner join circuit_checkin_registration_checkitem_info rgi
on rg.institution_number=rgi.institution_number and rg.registration_number=rgi.registration_number
where rg.institution_number=\'37070201\' and rg.invalid=0
and rgi.execute_status is not null and rgi.execute_status=3
GROUP BY rg.registration_number