Posted by Xavier Houppertz on 06/21/05 13:43

Hello,

I am experiencing problems in writing an sql query.
I would like to do a select count (pn_uid) where pn_did > 10 AND where
pn_did > 500 goup by and sort by

Of course if i do this I get everything that is above 500 (say 75)

But I would like a result like Uid >10 >500
18 25 75

I tried UNION, but I get two lines
Uid Tot
18 25
18 75

And i would like one ....

Ideas please ?

thanks,
Xavier

• Next in forum: Fine tuning mysql
• Prev in forum: Re: Database "pruning" tool?
• Thread view: 2 where clause in same statement Mysql 4.2

[Reply to this message]