Okay. I have one table called USERS, with fields like id, and then a bunch of "contact info" fields... just their profile really. Then I ahve another table called id_links, which has two columns -- id1 and id2...

Say I have 10 users... in users, id's 1-10...

In id_links, say I have:
1|2
1|3
4|1
1|5
6|1
7|1
8|1
1|9
10|1

As you can see 1 is linked to all other 9 ids.. but it occurs as both id1 or id2...

What I want to do is grab all "profiles" for each of the 9 users who are linked to id 1.. .so, that is id's 2-10... but I have to determine whether it is id1 or id2 that i want to get the info for.. how could I accomplish this? I just can't seem to build a query to do this...