Natural Joins Vs Where Clauses [duplicate]

This question already has answers here: Closed 11 years ago.

Possible Duplicate:

is NATURAL JOIN any better than SELECT FROM WHERE in terms o开发者_Go百科f performance ?

Is there an advantage to using natural joins vs a straight where clause in terms of SQL Server performance? I don't see it, but I'm wondering what the advantage is other than separation of join logic and filtering.

---

There is no such thing as NATURAL JOIN in SQL Server (a good thing or two)

If you mean explicit INNER JOIN syntax, then there is no performance difference

For more reasons why explicit is good, see my answer here
SQL JOIN: is there a difference between USING, ON or WHERE?

---

In short no - it's down to personal preference