ansi Joins

Does anyone know for sure if
tableA a join tableB b on a.key = b.key
is better than
tableA a, tableB b
where a.key = b.key
Thanks."dummy#1" <dummy1@.discussions.microsoft.com> wrote in message
news:99E78041-B5D1-444C-AF02-F9B9B07AC9A4@.microsoft.com...
> Does anyone know for sure if
> tableA a join tableB b on a.key = b.key
> is better than
> tableA a, tableB b
> where a.key = b.key
> Thanks.
Both should resolve to the same query plan.
If I don't get any advantage using a non-ANSI solution, I'll use the ANSI
solution every time.
Besides, I find the ANSI join syntax easier to read.
Just for jun, if you create a View using the other syntax and then load it
into Enterprise Manager's design view, it gets changed to the Ansi join.