Jump to content


This topic is now archived and is closed to further replies.


Need some data from other table instead

Recommended Posts

I've got this query:
[code]SELECT b.`inboxid`,a.`username`,b.`message` FROM users a, inbox2 b WHERE a.`userid`=b.`fromid` AND b.`fromid`='1' ORDER BY b.`inboxid` DESC[/code]
Which returns:

Problem is, instead of pulling my name from the users table (send TO) I need it to return the sent FROM from the users table. Is this possible or do I need to add another select query in my loop that gets the username from the users table?

Share this post

Link to post
Share on other sites


Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.