[thelist] sql query help
Yousuf Harichara
yousuf at priest.com
Fri May 24 12:11:00 CDT 2002
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
More information about the thelist
mailing list