Whatever, just be aware if you still have no transactions at all in the GiveTransactions table you won't get a result back as you are inner joining on it. Right now you are relying on there being transactions of types other than 2A and 6B to get rows back if there are no 2A or 2B transactions. Maybe there always will be, but you may need to left join or something.