help; a challenging SQL request

I need to write a SQL which find all the match recording for a particular person

For example

COL1               COL2
john                 a
john                 b
john                 c
joe                  a
joe                  c
tim                  a
tim                  b
tim                  c

I would like to find all the person who has the same entry as john (a, b,c ), which tim is.

How should i build that SQL?

Thanks for your help Received on Wed Jun 29 2011 - 10:08:32 CDT