Beefy Boxes and Bandwidth Generously Provided by pair Networks
Think about Loose Coupling

Comment on

( #3333=superdoc: 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:

WHERE CheckNo is not null WHERE DDNo is not null WHERE CheckNo is null AND DDNo is null

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.
Available for small or large Perl jobs; see my home node.

In reply to Re^5: SQL Database Table to Perl Script by aaron_baugher
in thread SQL Database Table to Perl Script by prithviraj

Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post; it's "PerlMonks-approved HTML":

  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.
  • Log In?

    What's my password?
    Create A New User
    and the questions are moot...

    How do I use this? | Other CB clients
    Other Users?
    Others examining the Monastery: (6)
    As of 2018-06-24 21:44 GMT
    Find Nodes?
      Voting Booth?
      Should cpanminus be part of the standard Perl release?

      Results (126 votes). Check out past polls.