By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,521 Members | 1,222 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,521 IT Pros & Developers. It's quick & easy.

SQL query cross match

P: 229
Hi, I have individual members pages by profileid

Expand|Select|Wrap|Line Numbers
  1. 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
Apr 2 '14 #1
Share this Question
Share on Google+
1 Reply

Expert Mod 10K+
P: 12,430
Return country in your main query so you can use it to filter in the second query.
Apr 2 '14 #2

Post your reply

Sign in to post your reply or Sign up for a free account.