[PHP] Joining same table twice

i apologize if its against the rules to post mysql questions here, though im using php to query the db so... i have a table with three integers. [table post] postuserid | replyuserid | parentid -- i do a left join on table user to get the username that postuserid

Re: [PHP] Joining same table twice

Sebastian wrote: i apologize if its against the rules to post mysql questions here, though im using php to query the db so... i have a table with three integers. [table post] postuserid | replyuserid | parentid -- i do a left join on table user to get the username