[AccessD] SQL verses system features

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.