MySQL Forums :: Newbie :: Simple statement

Advanced Search

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.



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

Options: ReplyQuote

Subject Written By Posted
Simple statement Flo Enne 06/15/2011 05:21PM
Re: Simple statement Rick James 06/16/2011 11:07PM
Re: Simple statement Flo Enne 06/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.