Hello all,
I have two tables:
Table1
%Key_Model, Number, Model, FromDate, ToDate
1,123456, Model1, 2012-01-01, 2012-01-31
2, 123456, Model2, 2012-02-01, 2012-04-30
3, 123654, Model3, 2012-03-01, 2012-12-31
... and so on
Table2
Number, Date, Fact
123456, 2012-01-01, 1
123456, 2012-02-10, 1
123654, 2012-02-11, 5
...and so on..
I would like to create a table like this.
Resulting table:
%Key_Model, Number,Date, Fact
1,123456, 2012-01-01, 1
2, 123456, 2012-02-10, 1
3, 123654, 2012-02-11, 5
I want my resulting table to contain the %Key_Model from table1 but only where the event from table2 is between the dates in table1.
Do you have any suggestions?
Br
cristian
