[thelist] sql query help

[Yousuf Harichara]

Maybe this:

select article_id, sum(sort_order)
from paragraphs
group by article_id
having sum(sort_order) = 4

1 am assuming the articles you are
not interested in will definitely
have a sort_order greater than 1

Yousuf

> >  -----Original Message-----
> > From: 	Chris Blessing [mailto:webguy at mail.rit.edu]
> > Sent:	Friday, May 24, 2002 9:00 AM
> > To:	thelist at lists.evolt.org
> > Subject:	[thelist] sql query help
> >
> > I thought something like this might work but it just returns some
> arbitrary
> > number of articles...
> >
> > select article_id from paragraphs
> > where sort_order = 1
> > group by article_id
> > having count(article_id) > 1
>

--
_______________________________________________
Sign-up for your own FREE Personalized E-mail at Mail.com
http://www.mail.com/?sr=signup