Group ,Sum ,Inner join ..How to do it ??

  • 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 !

  • 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)

  • the other 2 tables just have data that we don't use except the companyid. so we just want to join the tables in companyid that is the same in all tables . all the other fields are in the second one ..

    thanks

  • nvoyatzopoulos (11/11/2012)


    the other 2 tables just have data that we don't use except the companyid. so we just want to join the tables in companyid that is the same in all tables . all the other fields are in the second one ..

    thanks

    Then what is the purpose of the joins if you have all the data that you need for this exercise all in one?

    Also, if it really is one just one table with the data you're concerned with, it should be even easier for you to post some readily consumable data. Again, please read the article at the first link in my signature line below.

    --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)

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply