Re: not enough rows, too many rows, and joins
From: bugbear <bugbear_at_trim_papermule.co.uk_trim>
Date: Thu, 24 Feb 2005 11:29:42 +0000
Message-ID: <421dbb17$0$37370$ed2619ec_at_ptn-nntp-reader01.plus.net>
Date: Thu, 24 Feb 2005 11:29:42 +0000
Message-ID: <421dbb17$0$37370$ed2619ec_at_ptn-nntp-reader01.plus.net>
> And to the OP, you might want to review the difference between a joining
> condition in an ON clause, and a restriction on the final result in a WHERE
> clause, which is the root of your puzzlement.
Absolutely! With this statement, and your query, my problem is solved, and my understanding is improved.
Many thanks to all.
BugBear Received on Thu Feb 24 2005 - 12:29:42 CET