I know this can be done in a WITH clause, but that isn't at my disposal:

table1
-----
custId, someDate
1 , 2011-04-28 19:40:47
1 , 2011-07-07 13:27:57

table2
------
custId, anotherDate
1 , 2012-07-23 12:53:24
1 , 2012-10-16 14:33:37
1 , 2012-11-16 14:33:37

I need to create a start end range. I need to left join table2 onto table1 where min(anotherDate) > someDate for the same custId. Notice 2012-11-16 14:33:37 was excluded because it was not the min for someDate: 2011-07-07 13:27:57

Result:
custId, someDate, anotherDate
1 , 2011-04-28 19:40:47 , 2012-07-23 12:53:24
1 , 2011-07-07 13:27:57 , 2012-10-16 14:33:37