Stuart McLachlan
stuart at lexacorp.com.pg
Mon Aug 18 22:14:31 CDT 2003
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.