[AccessD] SQL verses system features

Non-key columns support joins, but that isn't the same thing as
relationships.  Relationships are enduring.  Joins can be temporary.

Charlotte Foust

-----Original Message-----
From: Susan Harkins [mailto:harkins at iglou.com] 
Sent: Tuesday, August 19, 2003 7:16 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] SQL verses system features


Thanks Stuart, but that's not the question -- did you answer the
question? I just want to know if it's a SQL standard that non-key
columns support relationships and thus, joins. I'm assuming from  your
response that the answer is Yes? :)

Susan H.


> On 18 Aug 2003 at 21:05, Susan Harkins wrote:
>
> > We all know that Access and SQL Server (I think, although frankly, 
> > I've
not
> > had reason to try) will allow you to relate tables on non-key 
> > fields.
> >
> > Now, is this a SQL feature or is it simply a feature of the 
> > individual systems? Does SQL-92 support joins on non-key columns?
> >
>
> In SQL , joins have nothing to do with indexes. Yuu can join any 
> fields as long as they compatible data types. Key columns/ indexes 
> just make the data retrieval faster.
>
>
> --
> Lexacorp Ltd
> http://www.lexacorp.com.pg
> Information Technology Consultancy, Software Development,System 
> Support.
>
>
>
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com 
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
>

_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com