[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
   bill.v_bills b_vb
      inner join
   blobs.v_doc_med b_vdm
      on (b_vb.pk_doc = b_vdm.pk_doc)
   b_vb.pk_patient is distinct from b_vdm.pk_patient


--- The GNUmed client.

reply via email to

[Prev in Thread] Current Thread [Next in Thread]