What's the advantage of using the "JOIN" syntax when joining SQL tables???
I work in a mixed environment where we use both SQL Servers and Sybase Servers.
All of the SQL Server developers write their joins using the SQL-92 syntax like this:
SELECT c.name, a.state FROM
Customers c JOIN Address a ON c.CustomerId = a.CustomerId
But all of the Sybase developers continue to write their joins using the SQL-89 syntax like this:
SELECT c.name, a.state FROM Customers c, Address a
WHERE c.CustomerId = a.CustomerId
I don't see much difference on these smaller queries, but I always get frustrated trying to read the SQL-89 syntax on larger queries. What's the difference and why do developers still use SQL-89 syntax???
It turns out that performance is the same. Rather than go into details myself, here's a good explanation on Stack Overflow:
http://stackoverflow.com/questions/334201/why-isnt-sql-ansi-92-standard-better-adopted-over-ansi-89
No comments:
Post a Comment