<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE>Message</TITLE>
<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>Hi Arthur,</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2>the dates in TableA are looking the same as in
TableB.</FONT></DIV>
<DIV><FONT face=Arial size=2>For Example: 01-02-2000 and can be
anything, but are all from different years.</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2>The dates in TableB are all dates between
01-01-1950 and 31-12-2000.</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2>What i need is the records from TableB from the 10
days before the dates that are present in TableA.</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2>I'll hope this explanes enough</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2>Pedro Janssen</FONT></DIV>
<DIV> </DIV>
<DIV> </DIV>
<BLOCKQUOTE
style="BORDER-LEFT: #000000 2px solid; MARGIN-LEFT: 5px; MARGIN-RIGHT: 0px; PADDING-LEFT: 5px; PADDING-RIGHT: 0px">
<DIV style="FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black"><B>From:</B>
<A href="mailto:artful@rogers.com" title=artful@rogers.com>Arthur Fuller</A>
</DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A
href="mailto:accessd@databaseadvisors.com"
title=accessd@databaseadvisors.com>accessd@databaseadvisors.com</A> </DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Tuesday, April 22, 2003 2:23
PM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> RE: [AccessD] 10 days
before</DIV>
<DIV><BR></DIV>
<DIV><SPAN class=171352112-22042003><FONT color=#0000ff face=Arial size=2>What
exactly do the dates in TableA look like? Are they all the same day and month,
or could they be anything? There's something odd about the way this is
modeled, methinks.</FONT></SPAN></DIV>
<DIV><SPAN class=171352112-22042003><FONT color=#0000ff face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=171352112-22042003><FONT color=#0000ff face=Arial
size=2>A.</FONT></SPAN></DIV>
<DIV><FONT face=Tahoma><FONT size=2><SPAN class=171352112-22042003><FONT
color=#0000ff face=Arial> </FONT></SPAN></FONT></FONT></DIV>
<DIV><FONT face=Tahoma><FONT size=2><SPAN
class=171352112-22042003> </SPAN>-----Original
Message-----<BR><B>From:</B> <A
href="mailto:accessd-bounces@databaseadvisors.com">accessd-bounces@databaseadvisors.com</A>
[<A
href="mailto:accessd-bounces@databaseadvisors.com">mailto:accessd-bounces@databaseadvisors.com</A>]
<B>On Behalf Of </B>Pedro Janssen<BR><B>Sent:</B> April 22, 2003 7:08
AM<BR><B>To:</B> AccessD@databaseadvisors.com<BR><B>Subject:</B> [AccessD] 10
days before<BR><BR></DIV></FONT></FONT>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<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></BLOCKQUOTE>
<P>
<HR>
<P></P>_______________________________________________<BR>AccessD mailing
list<BR>AccessD@databaseadvisors.com<BR>http://databaseadvisors.com/mailman/listinfo/accessd<BR>Website:
http://www.databaseadvisors.com<BR></BLOCKQUOTE></BODY></HTML>