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
