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... -- View this message in context: http://www.nabble.com/How-to-get-query-result-from-two-tables...-tf3416593.html#a9521748 Sent from the MySQL - General mailing list archive at Nabble.com. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]