MySQL Forums
Forum List  »  Newbie

Simple statement
Posted by: Flo Enne
Date: June 15, 2011 05:21PM

Hi guys,

I've got a relation with three columns: id, round, name
id holds the primary key. Now I want to select all names that are in all rounds.
For example:

id round name
1 1 mike
2 1 stephen
3 2 frank
4 2 mike

So mike is both in round 1 and round 2 and so I want to select him.
How can I do that?

Thanks in advance.

Cheers,

enne



Edited 1 time(s). Last edit at 06/15/2011 05:22PM by Flo Enne.

Options: ReplyQuote


Subject
Written By
Posted
Simple statement
June 15, 2011 05:21PM
June 16, 2011 11:07PM
June 17, 2011 06:54AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.