Have you tried selecting setting the where clause to
"Table2.date >= (Table1.date - 10) AND Table2.date <=
(Table1.date + 10)"
Tom Manson wrote:
> Okay people, how much do you know about Date functions in MI? Is it possible
> to select a row from Table1 where the date is within 10 days (for example)
> from another row in Table2? As far as I can tell, I can only select rows
> based on month, day of the week, day or year.
----------------------------------------------------------------------
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
