Re: extra table in from clause

From: Matthew Fuller <matthewlf_at_my-deja.com>
Date: Wed, 24 Jan 2001 19:15:15 GMT
Message-ID: <94n9jp$kid$1@nnrp1.deja.com>

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/
>

Your example didn't make it, but I believe your explanation is your answer--add a WHERE condition. And if you don't want all of the columns, specify them explicity in the SELECT list.

HTH. Matt.

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