Join Tables in MS SQL – FROM or WHERE clause?
Category: IT, MS SQL Server, MySQL Tags: IT, SSMS, Transact-SQL Comments: 0I 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