Display query result from two tables...

MySQL & MariaDB Other MySQL® Questions
1

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…

2
[B]aljosa.motore wrote on Fri, 16 March 2007 21:16[/B]
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…

Use a JOIN condition, like

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

HF :=)