Not the answer you need?
Register and ask your own question!

Display query result from two tables...

aljosa.motorealjosa.motore EntrantCurrent User Role Participant
I have two tables:
Table A:
Code | Name
100 | Name A
200 | Name B
300 | Name C

Table B:
Code | Date | Qty | Value
100 | 2007-01-01 | 10 | 123
100 | 2007-02-01 | -2 | 300
200 | 2007-02-01 | 3 | 100

What I want is to get this result:
Result Table on date example 2007-01-05:
Code | Name | Qty | Value
100 | Name A | 10 | 123

Result Table on date example 2007-02-05:
Code | Name | Qty | Value
100 | Name A | 8 | 300
200 | Name B | 3 | 100

And so on....

So, Table 1 is primary and Table B is some sort of history what happened with some "Code" on some dates.... What I want is to get result on certain date with right QTY on that date and also right Value on that date (or most nearest value).

Tahnks...

Comments

  • tanjtanj Contributor Inactive User Role Advisor
    <table border="0" align="center" width="90%" cellpadding="3" cellspacing="1"><tr><td class="SmallText">aljosa.motore wrote on Fri, 16 March 2007 21:16</td></tr><tr><td class="quote">
    I have two tables:
    Table A:
    Code | Name
    100 | Name A
    200 | Name B
    300 | Name C

    Table B:
    Code | Date | Qty | Value
    100 | 2007-01-01 | 10 | 123
    100 | 2007-02-01 | -2 | 300
    200 | 2007-02-01 | 3 | 100

    What I want is to get this result:
    Result Table on date example 2007-01-05:
    Code | Name | Qty | Value
    100 | Name A | 10 | 123

    Result Table on date example 2007-02-05:
    Code | Name | Qty | Value
    100 | Name A | 8 | 300
    200 | Name B | 3 | 100

    And so on....

    So, Table 1 is primary and Table B is some sort of history what happened with some "Code" on some dates.... What I want is to get result on certain date with right QTY on that date and also right Value on that date (or most nearest value).

    Tahnks...
    </td></tr></table>

    Use a JOIN condition, like

    SELECT code, name, qty, value FROM b INNER JOIN a USING (code) WHERE date = '2007-02-05';

    HF :=)
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.