How can I do a JOIN on nearby timestamps?

How can I do a JOIN on nearby timestamps?

References

Reference NO 1

http://stackoverflow.com/questions/4070476/sql-query-to-join-two-tables-based-off-closest-timestamp

Reference NO 2

http://stackoverflow.com/questions/9554685/selecting-the-last-entry-of-each-day-in-a-timestamp-and-corresponding-value

Reference NO 3

https://developers.google.com/bigquery/query-reference

Reference NO 4

http://dba.stackexchange.com/questions/6089/is-it-possible-to-compare-timestamps-between-rows

Reference NO 5

http://www.teradataforum.com/l070316a.htm

Reference NO 6

http://xchat.org/faq/

Reference NO 7

http://www.dbforums.com/sybase/1655151-column-named-timestamp-vbulletin-net-dataset.html

Reference NO 8

http://www.mmo-champion.com/threads/1177112-Lorewalker-s-Rep-Guide-Quick-and-Easy-with-Maps-and-Time-Stamps