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

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
>