Results 1 to 6 of 6
Aug 23, 2012, 15:49 #1
- Join Date
- Aug 2009
- 0 Post(s)
- 0 Thread(s)
SQL Join getting obtaining data for 2 users from an event.
Hey I have trouble joining tables in a way that I can obtain profile info from an event. Allow me to clarify. My website has an event table: user1(int), user2(int), event_type(int). Events join two users together.
Now, from this standpoint the data I have is the user ID. The user ID can either be at user1 or user2. Though I want to join the user table to obtain information for both users.
here is my statement:
Any help in the right direction is greatly appreciated.