MySQL Performance: MySQL => Display query result from two tables...

Display query result from two tables... [message #941]

Fri, 16 March 2007 16:16

aljosa.motore
Messages: 1
Registered: March 2007

Junior Member

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

Report message to a moderator