Sherif - 11:35 pm on Aug 10, 2010 (gmt 0)
That's what I expected, but i thought that there would be a better method which requires less coding in the query.
The remaining part that makes me confused, is that in many cases, there could be more than one payment that is associated with the same invoice number. How would this syntax/query treat this one to many relation in the output of this query? Would this query output the same row multiple times from the invoice table to satisfy the values from the payments table?
Again, thanks for your support and patience.