[Gnumed-devel] user contributed report

[GNUmed Report Generator]

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