query question really cant give a summary here so read the body ;-)

------=_Part_18511_33044583.1208974312074
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

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

------=_Part_18511_33044583.1208974312074
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

Hi all,<br><br>have the following table<br><br>aid&nbsp;&nbsp;&nbsp; |
bid<br>--------------<br>1&nbsp;&nbsp;&nbsp; |5<br>2&nbsp;&nbsp;&nbsp;
|6<br>3&nbsp;&nbsp;&nbsp; |7<br>4&nbsp;&nbsp;&nbsp;
|9<br>5&nbsp;&nbsp;&nbsp; |1<br>6&nbsp;&nbsp;&nbsp;
|2<br>7&nbsp;&nbsp;&nbsp; |3<br>8&nbsp;&nbsp;&nbsp;
|10<br>9&nbsp;&nbsp;&nbsp; |4<br>10&nbsp; |8<br>both aid &amp; bid
represent the same data in another table, but the table has duplicate data
and i did a self-join to get the id&#39;s out. The question is how do i get
a distinct listing between both columns<br>
<br>like<br>aid |
bid<br>-----------<br>1|5<br>2|6<br>3|7<br>4|9<br>10|8<br><br>Have been
racking my brain for the past hour....any
suggestions?<br><br>Thanks<br>Rhys<br>

------=_Part_18511_33044583.1208974312074--