[AccessD] SQL verses system features

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?

Susan H.