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