I was interested of the different SQL “accents”. According to Microsoft SQL Server learning books, we query like this:

SELECT
*

FROM
table1 INNER JOIN table2
ON table1.PK = table2.FK
GO