The MyChenQL insanity never ends

[filburt1]

Let's say I have two userids in one row, and I want a query to return the associated usernames with those userids. Normally I'd do this:
[sql]
SELECT t.userid, u.username FROM sometable t, user u WHERE t.userid = u.userid;
[/sql]
However I don't know what to do with two userids.

[Xenon]

hmm, sorry, i've read your post threa times now and don't get what you mean by two userid's in a row...

can you please explain it a bit more to me, and what you want to have

(paint a picture for dummy-me )

[filburt1]

Here's the schema for the table in question. What I want to do is first show off this kickass RDC on a Mac, and second get the usernames for both fromuserid and touserid.

[Xenon]

ahhh i see now

well i think this should work:

[sql]SELECT *.usertouserlog, username.fromuser AS fromusername, username.touser AS tousername FROM usertouserlog LEFT JOIN user AS fromuser ON (usertouserlog.fromuserid=fromuser.userid) LEFT JOIN user AS touser ON (usertouserlog.touserid = touser.userid)[/sql]

[filburt1]

Trying now. I knew it would probably involve joins.

[filburt1]

Unknown table 'username' in field list

...which makes sense...?

[Xenon]

hmm, intresting ^^

retry the query now, maybe it was because of my forgotten tablenames

[filburt1]

Got it working after half-rewriting the query . Helped me learn about JOINs, though.
[sql]
ELECT usertouserlog. * , fromuser.username AS fromusername, touser.username AS tousername
FROM usertouserlog
LEFT JOIN user AS fromuser ON ( usertouserlog.fromuserid = fromuser.userid )
LEFT JOIN user AS touser ON ( usertouserlog.touserid = touser.userid );
[/sql]