Re: query for point in time

atible schema to answer. > > An rdbms is a great general purpose question answering tool for structured > data. lucene/Solr is a great indexing tool for text matching. > > > On 9/15/2011 2:55 PM, gary tam wrote: > >> Hi >> >> I have a scenario that I am no

query for point in time

Hi I have a scenario that I am not sure how to write the query for. Here is the scenario - have an employee record with multi value for project, started date, end date. looks something like John Smith web site bug fix 2010-01-01 2010-01-03 u