Ok, after 335 lines of SQL and 778 lines of VB, this trial-by-fire SQL is complete and working! Thanks for your help Dave!

I have a similar problem joining some other tables. Lets assume the aforementioned PATIENT table and the following:

[font="Courier New"]

APPOINTMENTS

appt_id pt_id appt_date ...

DAVNovak (3/31/2008)

---

Using the derived tables is one solution. Here is another that looks very similiar:

SELECT p.name, p.dob, c1.charge, c2.charge, c3.charge

FROM patients p

LEFT OUTER JOIN charges c1...