I have the two tables below: Table A ----------- Date | Value 2006-09-01 | 100 2006-10-01 | 200 2006-07-01 | 50
Table B ----------- Date | Value 2006-09-13 | 100 2006-07-25 | 50 I need to do a dbproc showing the following result: RESULT -------------- PROGR | A.Date | A.VALUE | B.Date | B.Value 1 | 2006-07-01 | 50 | 2006-07-25 | 50 2 | 2006-09-01 | 100 | 2006-09-13 | 100 3 | 2006-10-01 | 200 | ? | ? HOW do i manage to obtain this result ?? Thanks in advance Luca
