Re: Avoid couples in the resultset

[Felix Geerinckx]

Schindler Judith wrote:

> select t1.id_topics, i1.id_indices , t2.id_topics
> from indices i1, indices i2, topics t1, topics t2
> where (i1.ind ='test' and i1.id_urls=t1.id_urls
> and i2.id_urls=t2.id_urls and i1.ind=i2.ind and
> t1.id_topics<>t2.id_topics)
>
> I would like to eliminate the "inverted" mates of couples in the resultset.

Replace <> in the last line of your query with <

--
felix
Please use BBCode to format your messages in this forum.