Re: What's this SQL doing?

From: Anurag Varma <avdbi_at_hotmail.com>
Date: Thu, 06 Nov 2003 05:06:28 GMT
Message-ID: <oFkqb.3891$QA.779@news02.roc.ny>

"Prince Of Thieves" <thief_NOSPAM_at_hotmail.com> wrote in message news:pskqb.189$373.3675_at_nnrp1.ozemail.com.au...
> Select c.clridx, n.price, n.perprice
> from clr c, sprice_clrsku n where c.styleidx = 1164
> and c.styleidx = c.styleidx and c.active = 1 and c.colouridx > 0 and
> n.spidx(+) = 163
> and n.clridx(+) = c.clridx order by c.clrcode;
>
> Notice the line "and c.styleidx = c.styleidx "? Why did the author set this
> SQL like this? Is this to accomplish something I do not know about?

Maybe the author makes the assumption that 1 sometimes is not equal to 1?

Jokes apart .. this does not make sense. strip out the c.styleidx = c.styleidx.

Anurag

>
> --
>
> Julian Milano
>
>
>
Received on Wed Nov 05 2003 - 23:06:28 CST