AW: [AccessD] SQL verses system features

AFAIK it is ANSI standard to be able to join ANY colums you
like as long as they are the same type -> "long" on "long"
"text" on "text" etc. what Jet does allow (which I dont think is poss.
in ANSI Sql ist the joinig of doubles on longs / ints etc.

hth

alun
 

-----Ursprüngliche Nachricht-----
Von: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]Im Auftrag von Susan
Harkins
Gesendet: Dienstag, 19. August 2003 17:33
An: Access Developers discussion and problem solving
Betreff: 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.
>
>
> > 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
>
>

_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com