<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE>Message</TITLE>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.2719.2200" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><SPAN class=845211812-08052003><FONT color=#0000ff
size=2>Dave,</FONT></SPAN></DIV>
<DIV><SPAN class=845211812-08052003><FONT color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=845211812-08052003><FONT color=#0000ff size=2>Nice article, but
it does not discuss the specific type of subquery that is the subject of the
original questioner; namely, the [ ]. syntax for subqueries.</FONT></SPAN></DIV>
<DIV> </DIV><!-- Converted from text/rtf format -->
<P><SPAN lang=en-us><B><FONT color=#0000ff>Charles Wortz</FONT></B></SPAN>
<BR><SPAN lang=en-us><FONT color=#0000ff>Software Development
Division</FONT></SPAN> <BR><SPAN lang=en-us><FONT color=#0000ff>Texas Education
Agency</FONT></SPAN> <BR><SPAN lang=en-us><FONT color=#0000ff>1701 N. Congress
Ave</FONT></SPAN> <BR><SPAN lang=en-us><FONT color=#0000ff>Austin, TX
78701-1494</FONT></SPAN> <BR><SPAN lang=en-us><FONT
color=#0000ff>512-463-9493</FONT></SPAN> <BR><SPAN lang=en-us><FONT
color=#0000ff>CWortz@tea.state.tx.us</FONT></SPAN> </P>
<DIV></DIV>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B> dave sharpe
[mailto:davesharpe2@cox.net] <BR><B>Sent:</B> Wednesday 2003 May 07
21:42<BR><B>To:</B> accessd@databaseadvisors.com<BR><B>Subject:</B> Re:
[AccessD] SQL in-line subquery<BR><BR></FONT></DIV>
<DIV><FONT size=2>Friends I found this on the subject and thought
that</FONT></DIV>
<DIV><FONT size=2>it might be of benefit to some members of the
group.</FONT></DIV>
<DIV><FONT size=2></FONT> </DIV>
<DIV><FONT size=2><A
href="http://www.nesug.org/Proceedings/nesug98/dbas/p005.pdf">http://www.nesug.org/Proceedings/nesug98/dbas/p005.pdf</A></FONT></DIV>
<DIV><FONT size=2></FONT> </DIV>
<DIV><FONT size=2>Dave</FONT></DIV>
<DIV><FONT size=2></FONT> </DIV>
<BLOCKQUOTE
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV style="FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black"><B>From:</B>
<A title=CWortz@tea.state.tx.us href="mailto:CWortz@tea.state.tx.us">Wortz,
Charles</A> </DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A title=accessd@databaseadvisors.com
href="mailto:accessd@databaseadvisors.com">accessd@databaseadvisors.com</A>
</DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Wednesday, May 07, 2003 12:45
PM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> RE: [AccessD] SQL in-line
subquery</DIV>
<DIV><BR></DIV>Also, about a year ago this subject was brought up with about
the same<BR>amount of information documented.<BR><BR>Charles
Wortz<BR>-----Original Message-----<BR>From: Charlotte Foust
[mailto:cfoust@infostatsystems.com] <BR>Sent: Wednesday 2003 May 07
11:16<BR>To: <A
href="mailto:accessd@databaseadvisors.com">accessd@databaseadvisors.com</A><BR>Subject:
RE: [AccessD] SQL in-line subquery<BR><BR>But, Gustav, we just created
references to it here! <VBG><BR><BR>Charlotte Foust<BR><BR>-----Original
Message-----<BR>From: Gustav Brock [mailto:gustav@cactus.dk] <BR>Sent:
Tuesday, May 06, 2003 11:51 PM<BR>To: <A
href="mailto:accessd@databaseadvisors.com">accessd@databaseadvisors.com</A><BR>Subject:
Re: [AccessD] SQL in-line subquery<BR><BR><BR>Hi Charlotte<BR><BR>>
.. If you ever find it in help, for goodness sake, post the
reference<BR><BR>> here!<BR><BR>I would say: if you ever find any reference
to this, post it
here.<BR><BR>/gustav<BR>_______________________________________________<BR>AccessD
mailing list<BR><A
href="mailto:AccessD@databaseadvisors.com">AccessD@databaseadvisors.com</A><BR><A
href="http://databaseadvisors.com/mailman/listinfo/accessd">http://databaseadvisors.com/mailman/listinfo/accessd</A><BR>Website:
<A
href="http://www.databaseadvisors.com">http://www.databaseadvisors.com</A><BR></BLOCKQUOTE></BODY></HTML>