delete from exam_info where exists( select a.exam_info_id from exam_info a inner join jx02 on jx02.jx02id = exam_info.kcdm where a.shzt <> '3' and a.exam_type_desc like '%选择题B%' and jx02.kcmc like '%中医皮肤科学%' and exam_info.exam_info_id = a.exam_info_id)如果exam_info_id是主键的话,这么删除不就好了
delete from exam_info where exists(
select a.exam_info_id from exam_info a
inner join jx02 on jx02.jx02id = exam_info.kcdm
where a.shzt <> '3' and a.exam_type_desc like '%选择题B%' and jx02.kcmc like '%中医皮肤科学%' and exam_info.exam_info_id = a.exam_info_id)如果exam_info_id是主键的话,这么删除不就好了