Re: How to select the <= date row?

> stefanbm_at_iafrica.com (Stefan Mahs) wrote in article
 <N.060696.151009.56_at_mickey.iafrica.com>...
> I need to get the complete status of a policy, or set of policies, as it
 

> was at any particular point in time. This means supplying at least a
 date
> at which the policy's value should be retrieved, say 1 Jan 1995.
 Normaly
> one would just join all the tables policy number, but in this case there
 

> may not be row for the specified date in one or more of the related
 event
> specific tables. In this case I need to get the row for the closesed
> previous date. The row with the largest date less than or equal to the
> specified date, is the one that was still in force at the specified
date.

Well, you could include a start and end date/time, index it, and use between for your date in question. Received on Thu Jun 20 1996 - 00:00:00 CEST