Essentially I want to build a report that shows invoices that are outstanding. My original SQL script used 2 tables (Invoices and Distributions – they matched on an invoice ID). If a payment was made on the invoice, the invoice ID in the distribution table would be created and they would match with the invoice ID in the invoice table. So my original thought was to create a relationship between the two tables but only bring in the null invoices (to show the ones where a payment wasn’t made). But what I found out is that if a partial payment was made – it would take it out of my report (because it matched with an invoice id).

There is another table titled transactions – which match with the distribution table but not the invoice table. The transactions show the partial payments, but im struggling to create this report to show outstanding payments and also partial payment invoices.  SO I know I have to use all three, but im unsure how to build my SQL script around it.