I had this query working perfectly before I added the second inner join on INVOICES table. After I added the INVOICES INNER JOIN it started producing double records in results. Its showing each result record twice. I need this fixed. This should be quick and easy for anyone who knows SQL better than me. lol
see Attatched query.