select a.zyghid zyid00,d.EXAM_REPORT_NO 检查号,c.jclbmc 检查类别名称 from yj_yw0000 a,bm_zlzd00 b,bm_jclb00 c,CDR_EXAM_REC@PACS d where a.zlxmid=b.zlxmid and b.jclbid=c.jclbid and a.yjdjh0=d.APPLY_SHEET_NO