[AccessD] SQL verses system features

Thanks Charles -- this should be useful. 

Susan H. 


> Susan,
> 
> Here is the home page for the SQL-1999 standards;
> http://www.service-architecture.com/database/articles/sql1999.html .
> 
> Charles Wortz
> Software Development Division
> Texas Education Agency
> 1701 N. Congress Ave
> Austin, TX 78701-1494
> 512-463-9493
> CWortz at tea.state.tx.us
> 
> 
> 
> -----Original Message-----
> From: Susan Harkins [mailto:harkins at iglou.com] 
> Sent: Tuesday 2003 Aug 19 10:33
> To: Access Developers discussion and problem solving
> Subject: Re: [AccessD] SQL verses system features
> 
> Right, but that's not what I'm asking. I must not be asking this right.
> 
> Systems aren't equal -- they all have little nuances that others don't
> have -- within the SQL context. But by and large, for the most part, the
> support in general is pretty inclusive.
> 
> What I'm asking is -- is th ability to join on non-key columns one of
> these little nusances of Jet and T-SQL or are both systems simply
> following the SQL standards when they allow this?
> 
> Is that better? I need to know if it's a SQL standard or just something
> some systems allow.
> 
> Susan H.
> 
> 
> > 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.
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> 
>