Re: query question really cant give a summary here so read the body ; -)

This works in oracle:

SELECT aid, bid
FROM aidbid
WHERE aid < bid
UNION
SELECT bid, aid
FROM aidbid
WHERE bid < aid

Rhys Stewart <rhys(dot)stewart(at)gmail(dot)com> wrote:
Hi all,

have the following table

aid | bid
--------------
1 |5
2 |6
3 |7
4 |9
5 |1
6 |2
7 |3
8 |10
9 |4
10 |8
both aid & bid represent the same data in another table, but the table has duplicate data and i did a self-join to get the id's out. The question is how do i get a distinct listing between both columns

like
aid | bid
-----------
1|5
2|6
3|7
4|9
10|8

Have been racking my brain for the past hour....any suggestions?

Thanks
Rhys

---------------------------------
Be a better friend, newshound, and know-it-all with Yahoo! Mobile. Try it now.