MySQL was introduced in the mid-1990s as ... using the "ON" command to identify the matching unique key for each table. For example: ...

I was trying to figure out what this could be, but my MySQL-fu may not be strong enough. The first thing that strikes me as odd is that in your SQL Server code example you have the tables ...