Jan
21
2010
Join Tables in MS SQL – FROM or WHERE clause?
Category: IT, MS SQL Server, MySQL Tags: IT, SQL, SSMS Comments: 0 »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
The MySQL guys makes queries like this:
SELECT *
FROM table1, table2
WHERE table1.PK = table2.FK;
Using Microsoft SQL Server 2008, I wrote a script to create and populate two tables [...]