[Gnumed-devel] SQL to find wrongly assigned bills

[Karsten Hilbert]

--- 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.