"Bob Barrows" wrote in
:

David W. Fenton wrote:

Uh, you're quoting examples of T-SQL. You haven't shown that the
results returned are different from Jet than within SQL Server.

Quick recap:
We were discussing why it would be better to put JOIN criteria in
the JOIN clause rather than the WHERE clause. I had suggested that
it would be better to get in the habit of doing it in the JOIN
clause so one would be be better prepared to make the move to SQL
Server. I supported that contention by explaining that putting
outer join criteria in the WHERE clause in SQL Server (not
possible in Jet) could produce different results than putting the
criteria in the JOIN clause. That's the only point I was
attempting to make.

And so far, you haven't done that, so far as I can see.

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/