Hello Friends,
Here i have two tables.
In Table A, there are some part no. with different created date and task no.
In Table B, there are some part no. with different ID no. and ID_Date.
Now
Example 1:
In Table A, Task No. 1, Part No. A and Created Date: 08/07/2013 10:27:03
Now i want to get ID No from Table B according to part no. and created date.
Task No. 1, Part No. A and Created date: 08/07/2013 10:27:03, So for same part no. immidiate first less date of created date in Table B is 08/07/2013 10:20:00
So ID No is ID_1
Example : 2
Task No. 3, Part No. A and Created date: 08/07/2013 12:27:03, So for same part no. immidiate first less Id_date of created date in Table B is 08/07/2013 10:30:00
So ID No is ID_2
Example : 2
Task No. 4, Part No. C and Created date: 08/07/2013 13:07:00, So for same part no. immidiate first less Id_date of created date in Table B is 08/07/2013 11:30:00
So ID No is ID_5
TABLE: A
| TASK NO. | CREATED BY | PART_NO | CREATED DATE |
|---|
| 1 | AAA | A | 08/07/2013 10:27:03 |
| 2 | AAA | B | 08/07/2013 11:00:00 |
| 3 | AAA | A | 08/07/2013 12:27:03 |
| 4 | BBB | C | 08/07/2013 13:07:00 |
| 5 | CCC | B | 08/07/2013 14:20:03 |
TABLE: B
| PART_NO | ID | ID_DATE |
|---|
| A | ID_1 | 08/07/2013 10:20:00 |
| A | ID_2 | 08/07/2013 10:30:00 |
| B | ID_3 | 08/07/2013 11:30:00 |
| B | ID_4 | 08/07/2013 12:00:00 |
| C | ID_5 | 08/07/2013 11:30:00 |
Please let me know how do i achive this result?
Thanks
