|
|
Posted by Piratron on 06/09/06 13:44
ZeldorBlat wrote:
>
> For illustration purposes suppose you only had 3 topics (topic_id's 20,
> 42, and 69). Then something like this should work:
>
> select member_id
> from theTable
> where topic_id in (20, 42, 69)
> group by member_id
> having count(distinct topic_id) = 3
>
Thank you very much, it works perfect ;)
--
------------------------------------------------------------------------
visit our site at:
www.symbian-mobile.org
Regards,
Symbian-Mobile Team
Navigation:
[Reply to this message]
|