Best Mysql structure
Posted by: William Glenn
Date: June 17, 2013 11:10AM
Ok all I need some quick help on this one.
I have a table say
ID, FirstName, LastName, Recruiter_ID
Which contains a rep's information and the ID of the person recruiting from the same table.. So let's take an example
ID 1000 recruits 1001, and 1001 recruits 1002 but 1000 needs to get credit for the whole volume 1001 and 1002 create.
What would be the best structure to find all of the ID's of recruits brought on by anyone under 1001?
Hope this makes sense?
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.