[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Gnumed-devel] SQL to find wrongly assigned bills
From: |
Karsten Hilbert |
Subject: |
[Gnumed-devel] SQL to find wrongly assigned bills |
Date: |
Wed, 5 Sep 2012 16:45:03 +0200 |
User-agent: |
Mutt/1.5.21 (2010-09-15) |
--- save this as a text file and drop it onto the Report
--- Generator inside GNUmed
--- This is a report definition contributed by a GNUmed user:
----------------------------------------
--- bills: find wrongly assigned bills
select pk_bill, invoice_id, b_vb.pk_patient as bill_patient, b_vdm.pk_patient
as doc_patient
from
bill.v_bills b_vb
inner join
blobs.v_doc_med b_vdm
on (b_vb.pk_doc = b_vdm.pk_doc)
where
b_vb.pk_patient is distinct from b_vdm.pk_patient
;
----------------------------------------
--- The GNUmed client.
- [Gnumed-devel] SQL to find wrongly assigned bills,
Karsten Hilbert <=