Hi, folks...

Couple of questions...

First, are there any known issues/advantages of doing tables joins in a JOIN vs WHERE? I had always believed the performance would be similar, but I recently saw the same query coded with a JOIN and then a WHERE...basic query against a large invoice tables and a join against a couple of masters. The JOIN syntax took 15 minutes, and the WHERE took about 11.


Related question...someone who recently attended a SQL Server 7 training class told me that the new ANSI standard is 'returning' to doing things in the WHERE as opposed to JOIN. I have not heard about this...anyone aware of this?

TIA,
Kevin