Hi to all,
here are given two queries:

1) SELECT * FROM A INNER JOIN B ON A=B
2) SELECT * FROM A, B WHERE A=B


I'd like to know the differences for the server to interpretate the one or
the other and, over all, which offers greater performances.

Thanks in advance, MadLuke.

The Queries ask to join on tables not columns of tables

If you meant columns of tables and what is the difference in the syntax then
in the case of SQL Server there is no difference. It is smart enough to
know you mean the same thing.



--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.konesans.com - Consultancy from the people who know


"MadLuke" <luca2510TOGLIMI (AT) hotmail (DOT) com> wrote

I already know the two queries get the same records but I'd like to know how
the server differently fetch them and over all the eventual performance
differences.

Bye, MadLuke.


"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> ha scritto nel messaggio
news:uflruhttEHA.2116 (AT) TK2MSFTNGP14 (DOT) phx.gbl...