Posted by Dan Guzman on 06/28/07 10:10

> I have one question about the standard join and inner join, which one
> is faster and more reliable? Can you recommend me to use? Please,
> explain me...

The ANSI-92 style INNER JOIN syntax is is recommended in Microsoft SQL
Server. The older join syntax is still accepted and both should provide the
same level of performance and reliability.

In the case of OUTER JOINs, older style joins (*= and =*) are sometimes
ambiguous (unreliable) so the ANSI-92 style OUTER JOIN syntax is strongly
recommended. The older style outer joins are only allowed in databases
with compatibility level lower than 90 and may not be supported in future
SQL Server versions.

--
Hope this helps.

Dan Guzman
SQL Server MVP

"Chamnap" <chamnapchhorn@gmail.com> wrote in message
news:1183007085.051745.221660@i38g2000prf.googlegroups.com...
> Hello, everyone
>
> I have one question about the standard join and inner join, which one
> is faster and more reliable? Can you recommend me to use? Please,
> explain me...
>
> Thanks
> Chamnap
>

• Next in forum: Re: DELETE where syntax ... need help :)
• Prev in forum: Re: DELETE where syntax ... need help :)
• Thread view: Re: Performance between Standard Join and Inner Join

[Reply to this message]