Posted by lallous on 02/27/06 00:27

Hello

I have a MySQL query question please.

I have two tables:

NAMES(id, name)
TABLE2(rowid, nameid1, nameid2, nameid3)

Example data (NAMES table)
-------------------------------
1 user1
2 user2
3 user3

Example data (TABLE2 table)
------------------------------
1 1 1 2
2 1 2 3
3 3 2 1

How can I write a query, passing it a 'rowid=1' and it should return
something like:
rowid=>1, name1=>'user1', name2=>'user1', name3=>'user2'

So, when I pass that query a given ROWID it would return (not the ids of the
users, but) the names of the users from the NAMES table.

Please advise if it is possible to write that one query, preferrable if it
is mysql 3.23 compatible.

--
Elias

[Back to original message]