I have two tables in SQLITE one table `FastData` records data at a high rate while the other table `SlowData` records data at a lower rate. `FastData` and `SlowData` share a primary key (`PK`) that represents time of data capture. As such the two tables could look like:

```
Fast Data         Slow Data
Pk   Value1       Pk   Value2
2    1            1    1
3    2            4    2
5    3            7    3
6    4
7    5
9    6

```

I would like to create a Select statement that joins these two tables filling in the `SlowData` with the previous captured data.

```
Join Data         
Pk   Value1  Value2
2    1       1
3    2       1
5    3       2
6    4       2
7    5       3
9    6       3

```