"Roger Gordon" <Roger@emojo.com> writes:
> When we use WITH (NOLOCK) at the end of table list in a SELECT query, a
> Cartesian join is returned (i.e. approximately 6,500 records instead of
> 57, which is distressing.
You'll have to post an actual query and output, preferably with an "explain
analyze" before anyone can help much. I certainly don't see this problem.
--
greg