displaying multiple values from one column with same value in anothe column

[hnumar7]

Hi Everyone,

 

I have a question which will probably be very easy to all the experts that are here on this forum.

 

I have a table called lists, and in this table I have 3 columns id, idname, userid

 

what I want to do is create a select statement that will list all the values from idname which contain the same userid

 

is this possible?

 

Thanks in advance for nay help I may receive.

 

 

[skateme]

select * from mytable where userid='SAMEUSERIDHERE';

 

Is that what you were looking for?