Bakes Posted March 21, 2009 Share Posted March 21, 2009 The structure of my table is: (id) (unix_datestamp) (old_owner) (new_owner) so, old_owner = id of one of my users and new_owner = id of one of my users I would like to get a list of the rows where the old_owner is in the group 'users' and the new_owner is also in the group 'users' unfortunately, I don't know how I could join them so that: users.group = grouplist.id users.id = history.old_owner users.id = history.new_owner how would I do this? Quote Link to comment Share on other sites More sharing options...
fenway Posted March 27, 2009 Share Posted March 27, 2009 show all three table structures. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.