Conditional sum query (2 replies)
(MySQL.com) I have a table called data that has an account number, location, and three payments that correspond to three dates.
Acct. Location Date1 Date2 Date3 Amt1 Amt2 Amt3
55 Tulsa 2010-03-17 2010-03-20 0000-00-00 45.66