This works in oracle:
SELECT aid, bid
FROM aidbid
WHERE aid < bid
UNION
SELECT bid, aid
FROM aidbid
WHERE bid < aid
Rhys Stewart <rhys.stewart@xxxxxxxxx> 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.
