Re: Out of temp space

From: DA Morgan <damorgan_at_x.washington.edu>
Date: Tue, 08 Mar 2005 07:59:00 -0800
Message-ID: <1110297346.76612@yasure>

Randy Harris wrote:

> "Randy Harris" <randy_at_SpamFree.com> wrote in message
> news:RF9Xd.17634$hU7.16508_at_newssvr33.news.prodigy.com...
>

>>Daniel, I'm not exactly sure how, but it has something to do with grouping
>>the segments in the WHERE clause.  I don't know how to state it, but I

>
> think
>

>>the join segment needs to be separated from the OR'd segment.  So far I
>>haven't been able to find an explanation in the SQL reference (though I'm
>>sure it's there), but I can get the query to run with the groupings.
>>
>>-- 
>>Randy Harris
>>(tech at promail dot com)

>
>
> You know, now that I've thought about this, it stands to reason. Without
> the proper grouping in the WHERE clause, I'm probably generating some sort
> of Cartesian product result. I never worried about it with just ANDs in the
> WHERE clause.
>
> Sorry for wasting the bandwidth with this posting storm.

Exactly. I just wanted to see the actual error message. You have not joined the tables and thus are creating a Cartesian product.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)

Received on Tue Mar 08 2005 - 09:59:00 CST