SQL query cross match

[fran7]

Hi, I have individual members pages by profileid

lngprofileid=CLng(Request("profileid"))

On these pages I am making a second query as I want to display other members who fall into a similar category (country) for example, to the member in the main query. Because the main query is by profileid and not the category (country) i cannot see how to get those members to display.


Any pointers would be great
Thanks
Richard

[Rabbit]

Return country in your main query so you can use it to filter in the second query.