Advertisement

06.30.2008 at 04:25AM PDT, ID: 23526505 | Points: 500
[x]
Attachment Details

Mutual Match Query

Asked by highlander_1969 in SQL Query Syntax, MS SQL Server

Tags: microsoft, sql server, all

Hi -  I run a dating site and have a feature called Yes-No-Maybe.

Basiclly members can click Yes/Maybe to each other. Whern they do this an entry is made in TBL_YesNoMaybe.

ChooserID is column name of the chooser
ChosenID is column name of the person they have chosen

My question is I want a SQL query to give me a recordset of the MUTUAL Yes/Maybes i.e. where
Person A has said YES to person B
Person B has said YES to person A

I will probably put this SQL into an SP. I know how to do do this for an individual person named by ID BUT I am wondering if there is a way of making a Query to return a recordset of ALL mutual yes/maybepeople












Start Free Trial
[+][-]06.30.2008 at 04:33AM PDT, ID: 21898161

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]06.30.2008 at 05:48AM PDT, ID: 21898596

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]06.30.2008 at 05:51AM PDT, ID: 21898612

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]06.30.2008 at 10:13AM PDT, ID: 21901042

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]06.30.2008 at 01:52PM PDT, ID: 21902943

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]06.30.2008 at 04:53PM PDT, ID: 21903946

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
 
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_2_20070628