[AccessD] SQL verses system features

Hi Susan,
To answer you question, IIRC...

No, the ability to join on non-key columns is not one of those little
nusances of Jet and T-SQL - well, since it says nusance(sic) and not nuance
I guess that's an opinion :o)

Yes, ANSI SQL (as far back as ANSI SQL Level 2 aka SQL '89) supports joins
on non-keyed columns.

John B.

PS:
ANSI SQL Joins create a new table of results by connecting one or more
columns in common.
ANSI SQL Keys (candidate, primary , foreign) are used to build referential
integrity.
ANSI SQL Indexes enhance performance (if used properly).

>
> 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.