Clear questions and runnable code get the best and fastest answer |
|
PerlMonks |
Re^5: SQL Database Table to Perl Scriptby aaron_baugher (Curate) |
on Oct 05, 2012 at 11:40 UTC ( [id://997451]=note: print w/replies, xml ) | Need Help?? |
Now can you give me the solution for this question please: If you're hungry and just want a fish to eat, I'll sell you one. If you want to learn to catch your own fish, that's a different situation. For your first question, you say you're already successfully getting the credit and debit values, so it looks to me like you'd get the account balance by subtracting one from the other. On the second question, it sounds like you want to group the results by whether the item has a CheckNo value, a DDNo value, or neither. It might be possible to do that with a single fancy SQL statement, but I'd probably just break my statement up into three, adding a WHERE clause to each, like these:
That way your first statement gets the check values, your second gets the DD values, and your third gets the cash values. I assumed that those fields are null when they aren't filled in. If they default to empty strings, you'll need to adjust accordingly. Hope that helps. Aaron B.
In Section
Seekers of Perl Wisdom
|
|