I have two seperate tables which I want to join based on Dates. However, I don't want the dates in the tables to be equal to one another I want the date (and accompanying value) from one table to be joined with the next date *available* after that date in the second table.

I've put an example of the problem below: 

Table 1:

```
Date          Value
2015-04-13    A   
2015-04-10    B
2015-04-09    C
2015-04-08    D

```

Table 2:

```
Date          Value
2015-04-13    E    
2015-04-10    F
2015-04-09    G
2015-04-08    H

```

Desired Output Table:

```
Table1.Date   Table2.Date   Table1.Value   Table2.Value
2015-04-10    2015-04-13    B              E
2015-04-09    2015-04-10    C              F
2015-04-08    2015-04-09    D              G

```

I'm at a bit of an ends of where to even get going with this, hence the lack of my current SQL starting point! 

Hopefully that is clear. I found this related question that comes close but I get lost on incorporating this into a join statment!!
[SQL - Select next date query](https://stackoverflow.com/questions/3609671/sql-select-next-date-query)

Any help is much appreciated!

M.

EDIT- There is a consideration that is important in that the day will not always be simply 1 day later. They need to find the next day *available*, which was in the original question but Ive update my example to reflect this.