跟踪
--医生-查询-预约病人查询
SELECT A.GHSJD0, B.BRXM00, B.BRDH00, B.BRJTDZ, A.JZRQ00   FROM SF_BRXXB0 A, BM_BRXXB0 B WHERE A.BRID00=B.BRID00 AND A.JZRQ00 BETWEEN '20211022' AND '20211022' AND A.JZYS00= 1513 AND A.JZRQ00||SUBSTR(A.GHSJD0,1,8) BETWEEN '2021102201:00:00' AND '2021102223:00:00' and A.THBZ00<>'0' AND A.GHSJD0 IS NOT NULL ORDER BY A.JZRQ00||SUBSTR(A.GHSJD0,1,8)


--护士-查询-门诊病人预约信息查询
 select * from vw_yy_bryyxxcx where 
 DJRQ00>='20211022' and DJRQ00<='20211022' 
 and YYZT00='0'
 order by YYKSBH,YYYSBH,YYH000