I'd say you need to rethink your schema. On Wed, Apr 23, 2008 at 12:11 PM, 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 >
