syber - 3:10 pm on Aug 11, 2010 (gmt 0)
Ok, I assumed a one-to-one relationship.
The LEFT JOIN will give you multiple rows when there are multiple payments for the same invoice. I guess where I got confused was on why you were trying to do a RIGHT JOIN initially. Do you have payments that don't have an invoice number attached?