Is it possible to join two tables by the nearest date? For example how
could I find out where the user was on their birthday?
users (id, name, birthday)
1 | one | 2009-07-27
2 | two | 2009-07-28
3 | three | 2009-07-29
4 | four | 2009-07-30
5 | five | 2009-07-31
users_locations (id, user_id, created)
1 | 1 | 2009-05-21
2 | 1 | 2009-06-21
3 | 1 | 2009-07-21
4 | 2 | 2009-05-10
5 | 2 | 2009-06-10
6 | 2 | 2009-07-10