HELP! Need to do this Query
From: Ian McDonald <ian_at_softopt.co.uk>
Date: 1996/04/11
Message-ID: <316D24BE.3C9F_at_softopt.co.uk>#1/1
Date: 1996/04/11
Message-ID: <316D24BE.3C9F_at_softopt.co.uk>#1/1
Hi folks,
I can't seem to get my head around this query. I wondered if anyone could offer a suggestion.
I have two tables of information as follows:-
People | Combinations ====== | ============ | Name + Interest | Name + Interest --------------+-------------- | --------------+-------------- Ian + Football | All Sports + Football Ian + Cricket | All Sports + Cricket Ian + Tennis | All Sports + Tennis Tom + Football | Team Sports + Football Tom + Cricket | Team Sports + Cricket Fred + Football |
I wish the query to work as follows:-
- Select the 'people.name' from 'people' which have the same interests as from 'combinations', 'combinations.name=All Sports'? ONLY RETURNS: Ian.
- Select the 'people.name' from 'people' which have the same interests as from 'combinations', 'combinations.name=Team Sports'? ONLY RETURNS: Tom.
If anyone has any ideas, please e-mail me:- ian_at_softopt.co.uk
Thanks in advance.
Ian McDonald Received on Thu Apr 11 1996 - 00:00:00 CEST