[AccessD] SQL verses system features

Well, I just went through a breakup, so maybe that's why I thought of
it! <G>
 
Charlotte Foust

	-----Original Message-----
	From: Hale, Jim [mailto:jim.hale at fleetpride.com] 
	Sent: Tuesday, August 19, 2003 11:55 AM
	To: 'Access Developers discussion and problem solving'
	Subject: RE: [AccessD] SQL verses system features
	
	

	<Relationships are enduring.  Joins can be temporary.> 
	Sounds just like the dating game <VBG> 
	Jim Hale 

	-----Original Message----- 
	From: Charlotte Foust [mailto:cfoust at infostatsystems.com] 
	Sent: Tuesday, August 19, 2003 10:23 AM 
	To: Access Developers discussion and problem solving 
	Subject: RE: [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 
	_______________________________________________ 
	AccessD mailing list 
	AccessD at databaseadvisors.com 
	http://databaseadvisors.com/mailman/listinfo/accessd 
	Website: http://www.databaseadvisors.com 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030819/1df20079/attachment-0001.html>