SELECT ...
FROM MyTable A
JOIN OtherTable B ON A.ThisColumn = B.ThatColumn
...

SELECT ...
FROM MyTable
JOIN TempTable ON MyTable.Timestamp BETWEEN TempTable.RangeBegin
                                        AND TempTable.RangeEnd
WHERE ...