Home Forums SQL Server 2008 T-SQL (SS2K8) Group ,Sum ,Inner join ..How to do it ?? RE: Group ,Sum ,Inner join ..How to do it ??

  • November 11, 2012 at 9:02 am

    #1557959

    nvoyatzopoulos (11/11/2012)

    Hello , i'm new and i want your help guys! I've 3 tables with one common field (id) .

    the data look like this ..

    companyid |datetrn |income| expenses | tax income | tax expenses |..

    01 |2012/01/01|100 | 0 | 0 | 10 |..

    02 |2012/02/15|0 | 150 | 12 | 0 |..

    03 |2012/03/20|1500 | 1000 | 0 | 100 |..

    so here start the troubles .. I want to join those 3 tables with id (ok with this) and present results like the following ..

    inc. sum|exp.sum|tot.period|in.tax sum|ex.tax sum|tot.period

    january | 100 | 0 | 100 | 0 | 10 | 10

    february | 0 | 150 | 50 | 12 | 0 | -2

    march | 1000 | 0 | 1050 | 0 | 100 | 98

    ........

    Is this possible ?

    thanks in advance !

    I suspect that you don't have an answer yet because there's just not enough information to go on. For example, you say you have 3 tables but show the data for only one and that data isn't readily consumable for someone to help you.

    With that thought in mind, please read the article at the first link in my signature line below for how to give your post the absolute best chance to be answered.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)