<!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.2800.1170" name=GENERATOR></HEAD>
<BODY>
<DIV><SPAN class=218110420-19082003><FONT face="Comic Sans MS" color=#0000ff
size=2>Well, I just went through a breakup, so maybe that's why I thought of it!
<G></FONT></SPAN></DIV>
<DIV><SPAN class=218110420-19082003><FONT face="Comic Sans MS" color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=218110420-19082003><FONT face="Comic Sans MS" color=#0000ff
size=2>Charlotte Foust</FONT></SPAN></DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV></DIV>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left><FONT
face=Tahoma size=2>-----Original Message-----<BR><B>From:</B> Hale, Jim
[mailto:jim.hale@fleetpride.com] <BR><B>Sent:</B> Tuesday, August 19, 2003
11:55 AM<BR><B>To:</B> 'Access Developers discussion and problem
solving'<BR><B>Subject:</B> RE: [AccessD] SQL verses system
features<BR><BR></FONT></DIV>
<P><FONT size=2><Relationships are enduring. Joins can be
temporary.></FONT> <BR><FONT size=2>Sounds just like the dating game
<VBG></FONT> <BR><FONT size=2>Jim Hale</FONT> </P>
<P><FONT size=2>-----Original Message-----</FONT> <BR><FONT size=2>From:
Charlotte Foust [<A
href="mailto:cfoust@infostatsystems.com">mailto:cfoust@infostatsystems.com</A>]</FONT>
<BR><FONT size=2>Sent: Tuesday, August 19, 2003 10:23 AM</FONT> <BR><FONT
size=2>To: Access Developers discussion and problem solving</FONT> <BR><FONT
size=2>Subject: RE: [AccessD] SQL verses system features</FONT> </P><BR>
<P><FONT size=2>Non-key columns support joins, but that isn't the same thing
as</FONT> <BR><FONT size=2>relationships. Relationships are
enduring. Joins can be temporary.</FONT> </P>
<P><FONT size=2>Charlotte Foust</FONT> </P>
<P><FONT size=2>-----Original Message-----</FONT> <BR><FONT size=2>From: Susan
Harkins [<A href="mailto:harkins@iglou.com">mailto:harkins@iglou.com</A>]
</FONT><BR><FONT size=2>Sent: Tuesday, August 19, 2003 7:16 AM</FONT>
<BR><FONT size=2>To: Access Developers discussion and problem solving</FONT>
<BR><FONT size=2>Subject: Re: [AccessD] SQL verses system features</FONT>
</P><BR>
<P><FONT size=2>Thanks Stuart, but that's not the question -- did you answer
the</FONT> <BR><FONT size=2>question? I just want to know if it's a SQL
standard that non-key</FONT> <BR><FONT size=2>columns support relationships
and thus, joins. I'm assuming from your</FONT> <BR><FONT size=2>response
that the answer is Yes? :)</FONT> </P>
<P><FONT size=2>Susan H.</FONT> </P><BR>
<P><FONT size=2>> On 18 Aug 2003 at 21:05, Susan Harkins wrote:</FONT>
<BR><FONT size=2>></FONT> <BR><FONT size=2>> > We all know that
Access and SQL Server (I think, although frankly, </FONT><BR><FONT size=2>>
> I've</FONT> <BR><FONT size=2>not</FONT> <BR><FONT size=2>> > had
reason to try) will allow you to relate tables on non-key </FONT><BR><FONT
size=2>> > fields.</FONT> <BR><FONT size=2>> ></FONT> <BR><FONT
size=2>> > Now, is this a SQL feature or is it simply a feature of the
</FONT><BR><FONT size=2>> > individual systems? Does SQL-92 support
joins on non-key columns?</FONT> <BR><FONT size=2>> ></FONT> <BR><FONT
size=2>></FONT> <BR><FONT size=2>> In SQL , joins have nothing to do
with indexes. Yuu can join any </FONT><BR><FONT size=2>> fields as long as
they compatible data types. Key columns/ indexes </FONT><BR><FONT size=2>>
just make the data retrieval faster.</FONT> <BR><FONT size=2>></FONT>
<BR><FONT size=2>></FONT> <BR><FONT size=2>> --</FONT> <BR><FONT
size=2>> Lexacorp Ltd</FONT> <BR><FONT size=2>> <A
href="http://www.lexacorp.com.pg"
target=_blank>http://www.lexacorp.com.pg</A></FONT> <BR><FONT size=2>>
Information Technology Consultancy, Software Development,System
</FONT><BR><FONT size=2>> Support.</FONT> <BR><FONT size=2>></FONT>
<BR><FONT size=2>></FONT> <BR><FONT size=2>></FONT> <BR><FONT
size=2>> _______________________________________________</FONT> <BR><FONT
size=2>> AccessD mailing list</FONT> <BR><FONT size=2>>
AccessD@databaseadvisors.com </FONT><BR><FONT size=2>> <A
href="http://databaseadvisors.com/mailman/listinfo/accessd"
target=_blank>http://databaseadvisors.com/mailman/listinfo/accessd</A></FONT>
<BR><FONT size=2>> Website: <A href="http://www.databaseadvisors.com"
target=_blank>http://www.databaseadvisors.com</A></FONT> <BR><FONT
size=2>></FONT> <BR><FONT size=2>></FONT> </P>
<P><FONT size=2>_______________________________________________</FONT>
<BR><FONT size=2>AccessD mailing list</FONT> <BR><FONT
size=2>AccessD@databaseadvisors.com</FONT> <BR><FONT size=2><A
href="http://databaseadvisors.com/mailman/listinfo/accessd"
target=_blank>http://databaseadvisors.com/mailman/listinfo/accessd</A></FONT>
<BR><FONT size=2>Website: <A href="http://www.databaseadvisors.com"
target=_blank>http://www.databaseadvisors.com</A></FONT> <BR><FONT
size=2>_______________________________________________</FONT> <BR><FONT
size=2>AccessD mailing list</FONT> <BR><FONT
size=2>AccessD@databaseadvisors.com</FONT> <BR><FONT size=2><A
href="http://databaseadvisors.com/mailman/listinfo/accessd"
target=_blank>http://databaseadvisors.com/mailman/listinfo/accessd</A></FONT>
<BR><FONT size=2>Website: <A href="http://www.databaseadvisors.com"
target=_blank>http://www.databaseadvisors.com</A></FONT>
</P></BLOCKQUOTE></BODY></HTML>