Re: extra table in from clause

From: <steveee_ca_at_my-deja.com>
Date: Wed, 24 Jan 2001 19:11:20 GMT
Message-ID: <94n9cf$kd5$1@nnrp1.deja.com>

Hi,

What is it you're trying to do? Maybe if you post your SQL, we'll have a better idea..if the table you're adding is totally unrelated to the other joined tables, you 'll get a Cartesian product, the set of all possible combinations because you haven't specified anything to limit the records returned through a join. That said, there is probably a way of achieving what you need, but you may just need a new approach.

Even the version of Oracle you're using has an impact on the possible solutions (in line views etc) and you haven't posted that..

Best wishes,

Steve

In article <94n8pc$jpv$1_at_nnrp1.deja.com>, pankrateon_at_my-deja.com wrote:
> how do I avoid doing a cartesian prodcut with a join?
>
> I'm doing a query and when I add an extra table in the from clause
> without adding a where condition that does a join on any of the
> columns with in that extra table, example:
>
> Sent via Deja.com
> http://www.deja.com/
>

Sent via Deja.com
http://www.deja.com/ Received on Wed Jan 24 2001 - 13:11:20 CST