[AccessD] SQL verses system features

Bob Hall rjhjr at cox.net
Tue Aug 19 12:56:05 CDT 2003


On Tue, Aug 19, 2003 at 11:15:49AM -0400, Susan Harkins wrote:
> 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? :)

There's nothing in any of the SQL standards that forbids joining on 
non-key columns. There's nothing in the SQL standards that requires SQL 
to know about relationships stored in a database's meta-tables and 
enforced by the DBMS. Stuart did answer your question, but his use of  
terms was more standard that yours.

Bob Hall


More information about the AccessD mailing list