[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
>
>