<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content="text/html; charset=iso-8859-1" http-equiv=Content-Type>
<META content="MSHTML 5.00.2920.0" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT face=Arial size=2>Hello Group,</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2>i have two tables</FONT></DIV>
<DIV><FONT face=Arial size=2>Tablea has 1 field with dates (1 date per
year)</FONT></DIV>
<DIV><FONT face=Arial size=2>and TableB has 1 date field (1 record per date from
all dates between 1950 and 2002) and 10 number fields.</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2>What i need is from all the dates that are present
in TableA, all the records from TableB for 10 days back.</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2>TIA</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2>Pedro Janssen</FONT></DIV></BODY></HTML>