Normalized data giving you problems? Learn how to use the SQL subselect statement and handle your database like a pro! Do you ever find yourself juggling queries to get the information you need?
invoice_noinvoice_dateinvoice_amountpayment_amount*payment_date** means that more than one payment can exist against the invoice.All the info is in the same table, and the relationship of the invoice ...