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? Link to comment https://forums.phpfreaks.com/topic/150453-two-query-two-different-sets-of-data-from-same-table/ Share on other sites More sharing options...
fenway Posted March 27, 2009 Share Posted March 27, 2009 show all three table structures. Link to comment https://forums.phpfreaks.com/topic/150453-two-query-two-different-sets-of-data-from-same-table/#findComment-795255 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.