<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META NAME="Generator" CONTENT="MS Exchange Server version 5.5.2654.45">
<TITLE>RE: [AccessD] SQL verses system features</TITLE>
</HEAD>
<BODY>
<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>
</BODY>
</HTML>