```
Table_A

A_id          
1     

Tale_B
B_id       A_id
1            1
2            1
3            1

Table_C

B_id      Process_date
1   20130101 12:20:01
2   20130101 12:10:01
3   20130101 13:00:01

```

How to retrieve the maximum process\_date from Table\_C with references of Table\_A A\_id based on Table\_C timing window.If i want to retrieve Table\_C id and max(process\_date) in timing window 20130101 12:09:00 to 12:21:00 then it should return id as 1 and process\_date as 12:20:01