Join two queries 1

[aarushi2001]

Hi,

I have no idea how to write a query for the following problem:

I have two table x and y
table x has id and name, while table y has id and value.
x.id is referencing y.id
I want to view all ids related to a particular name. So far I have achieved this much. But instead of showing id numbers, I want to extract the value of the particular id and display it. i.e. instead of displaying
id: 1,2,3,4,5 etc.. I want to display
id: x,y,z,a,b,c etc..


What shud I do?

 

[KarveR]

select y.value from x, y where x.id=y.id and x.name='someone';

______________________________________________________________________
There's no present like the time, they say. - Henry's Cat.

 

[aarushi2001]

thank u