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.


--
HTH,
Bob Barrows