[SOLVED] Help on select

[Beppi]

Hello.

I hope not to be on the wrong place, to ask a help on a select.

 

This is a conceptual problem I've been going around for some time. I'm pretty sure that it's a really basic question, but, anyway, I cannot find any solution anywhere....

 

I've got a table like this:

iduser_id1user_id2

1xy

2xz

3wz

 

And another table similar to this:

 

user_idname

xJohn

yPaul

zRingo

wGeorge

 

 

How can I get the result of the first table, with the names, instead of the ids?

So, this result?

user_name1user_name2

JohnPaul

JohnRingo

GeorgeRingo

 

 

Thank you very much for the help that you'll give me

 

Beppi.

[Barand]

SELECT t1.name, t2.name
FROM atable a
INNER JOIN anothertable t1 ON a.user_id1 = t1.user_id
INNER JOIN anothertable t2 ON a.user_id2 = t2.user_id

 

Treat the single physical "anothertable" as two logical tables t1 and t2

[Beppi]

Uuuh!! Logical table!!

Many thanks, really.