怎么实现exists

[xgfzxy]

select t.* from
mr_case_patient t where 1=1 and exists (select 1 from mr_case_diagnose --诊断表
where DISEASE--诊断名称
like 'A41.0%' and visit_id = t.visit_id )

大佬，我要以诊断名称来查，是不是只能通过自定义sql来了？