Clients belong to 2 type of categories, 1- seeker, 2-responder. when a person seeks his id will be entered in f1 and the person's id whom he wants to respond will be entered in f2. So 96 (example id) will be present as a seeker in some row and in responder in some rows. If i wanted to know whom all i have contacted (seeker or responder), how do i write the query?
So, if I understand correctly, you want to search for all the rows with 96 in either f1 or f2, and return the other id, eg f2 for rows where f1 = 96 or f1 for rows where f2 = 96?