select rownum xh0000,cykbmc,bah000,brxm00,cyrq00,zyysmc,
(select zdm000 from bq_baszdb zd where zd.zyid00= ba.lsh000 and zdlb00='3' and rownum <=1  ) zyzdbm,
(select zdmc00 from bq_baszdb zd where zd.zyid00= ba.lsh000 and zdlb00='3' and rownum <=1  ) zyzdmc,
(select ssm000 from ba_basssb ss where ss.lsh000= ba.lsh000 and sslb00='1' and rownum <=1  ) zssbm0,
(select ssmc00 from ba_basssb ss where ss.lsh000= ba.lsh000 and sslb00='1' and rownum <=1  ) zssmc0
 from   ba_brzyxx ba where 1=1  and ba.lsh000 in ( select distinct BA.LSH000   from BA_BRZYXX BA
                           join BA_BASSSB SS on BA.LSH000=SS.LSH000   where   cyrq00 >='20230716'  and cyrq00<='20230815' and cykbmc='妇产科'   and instrb(QKYHDJ,'I')>0  )