17,113
社区成员
发帖
与我相关
我的任务
分享请教怎样在结果中过滤筛选
想在下面这句的结果中再使用此语句通过a.patient_id和b.item_code相等的并且每条数据的a.visit_date-7天内是否也有记录。
select a.patient_id,a.name,a.identity,a.charge_type,b.item_name,b.item_code,b.visit_date,b.rcpt_no
from outp_rcpt_master A,outp_bill_items B where
A.rcpt_no=B.rcpt_no
AND A.CHARGE_INDICATOR<>'2' and b.item_class in ('A','B')
and a.visit_date>= to_date('2023-04-01','yyyy-mm-dd')
and a.visit_date< to_date('2023-04-10','yyyy-mm-dd') and b.performed_by='250801'
group by a.patient_id,a.name,a.identity,a.charge_type,b.item_name,b.item_code,b.visit_date,b.rcpt_no
...全文
请发表友善的回复…
发表回复
vfp_system 2023-05-23
- 打赏
- 举报
SELECT
a.patient_id,
a.name,
a.identity,
a.charge_type,
b.item_name,
b.item_code,
b.visit_date,
b.rcpt_no
FROM
outp_rcpt_master A,
outp_bill_items B
WHERE
A.rcpt_no = B.rcpt_no
AND A.CHARGE_INDICATOR <> '2'
AND b.item_class IN ('A', 'B')
AND a.visit_date >= TO_DATE('2023-04-01', 'yyyy-mm-dd')
AND a.visit_date < TO_DATE('2023-04-10', 'yyyy-mm-dd')
AND b.performed_by = '250801'
AND EXISTS (
SELECT 1
FROM outp_rcpt_master subA, outp_bill_items subB
WHERE subA.rcpt_no = subB.rcpt_no
AND subA.patient_id = a.patient_id
AND subB.item_code = b.item_code
AND subA.visit_date >= a.visit_date - 7
AND subA.visit_date < a.visit_date
)
GROUP BY
a.patient_id,
a.name,
a.identity,
a.charge_type,
b.item_name,
b.item_code,
b.visit_date,
b.rcpt_no;
