Welcome Guest, Not a member yet? Register   Sign In
Complex join statement
#1

[eluser]crumpet[/eluser]
I'm programming a private message system for users. The table pmessages stores userID's in the field mRecipient and mAuthor. When I access a message I want to join both those fields to the field userID in the table users so i can display usernames instead of userID's

Is there syntax to do this in one query or do i need to do two...?

basically i want to join two seperate fields in one table to the same field in another table


Messages In This Thread
Complex join statement - by El Forum - 06-08-2008, 01:27 PM
Complex join statement - by El Forum - 06-09-2008, 05:42 AM



Theme © iAndrew 2016 - Forum software by © MyBB