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

[Back to original message]