enders on 10 Apr 2015 14:33:07
We use a lot temporal databases because of compliance. Temporal databases can be modelled in SQL but querying them is a bit tricky. More information about temporal databases can be found here http://en.wikipedia.org/wiki/Temporal_database
Basicly you should have a "between" join.