i'm actually using postgreSQL but sql language doesnt change for mySQL, right? and nobody replied over at the postgre section so i tought maybe somebody here would

i'll describe my problem with a simplier example
lets say i have the following tables:

create table names(
id serial PRIMARY KEY,
name text
);

create table x(
x1 integer REFERENCES names (id),
x2 integer REFERENCES names (id),
x3 integer REFERENCES names (id)
);

so... my names table is populated with

id | name
-----------
1 | name1
2 | name2
3 | name3
4 | name4
5 | name5

and my x table contains the following:

x1 | x2 | x3
--------------
2 | 3 | 5
1 | 4 | 2


now, what i need is to make a query similar to:
select name from names,x where x.x1=names.id;


but the tricky thing is that i need to list the 3 names
for example for the first row of the x table (2, 3,5), i would need to get a list looking like this:

name | name | name
----------------------------
name2 | name3 | name5




i have tried a lot of combinations of queries but havent succeded, the closest i get is

name
--------
name2
name3
name5


if this is not possible let me know so i can stop trying

hmmm, i missed your post in the postgresql forum, i would've responded earlier, must have been the [hic] christmas spirits, ehrudy
http://r937.com/

thanks!!!
i would have never come up with that