I have two tables called test_master and test_detail. Both tables contains pos_id as common field. In test_detail got sub_id and to get the people under a given pos_id, I join with pos_id of test_master.
In the where condition, when I give the pos_id, it's returning only the first level. How can I get the second level and get all the levels?