Thanks.
--
Julian Milano
"Anurag Varma" <avdbi_at_hotmail.com> wrote in message
news:oFkqb.3891$QA.779_at_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 Thu Nov 06 2003 - 00:03:19 CST
