[RESOLVED] Finding Results that have not in another table?

[itsallgood]

Hi guys,

I'm sorry about the title of this post - i could not think of a short way of explainning what it is i want to do. :queasy:

I have 3 tables:

#Men-table
ManID	ManName
1	Bob
2	Dick
3	Ron
4	Paul
5	Steve
6	Jack
7	Jim

#Women-table
WomanID	WomanName
1	Amy
2	Sal
3	Val
4	Marie
5	Jane
6	Kim

#Relations-table
RelationID	ManID	WomanID
1		1	4
2		3	2
3		4	1

What i would like to do, is have a mysql query that would show which men are not in the relations-table. So the output of the query would be:

Result...
2	Dick
5	Steve
6	Jack
7	Jim

As these men are not in the relationships table.

Is this possible? or would it need to be done in php instead of sql?

Thanks so much for anyones help!

Regards.

[johanafm]

SELECT * FROM Mentable WHERE Mentable.ManID NOT IN (SELECT RelationTable.ManID FROM RelationTable)

[itsallgood]

johanafm -- that is amazing! Thanks so much 🙂

You guys are amzing on here! I've been searching for ages on how to do this query, and i just couldnt work it out.

Thanks again!