SELECT na.assessor_name, ns.state_name, na.jobrole_id, na.id, na.qualification, na.experience FROM nexus_assessors na INNER JOIN nexus_state ns ON ns.id = na.state_id WHERE na.status ='active' AND na.isdeleted='0' AND na.sector_id = '23' ORDER BY na.assessor_name ASC
Name | Jobroles | State | Qualification | Experience |
---|---|---|---|---|
Mukul Bera | West Bengal | Army-Graduate | 18 Years | |
Raktim Das | Tripura | B.E in Food Engg.&sTech. | 2 Years | |
Sukumar Basak | West Bengal | Army-Graduate | 19 Years | |
Susanta Kumar Koley | West Bengal | Army-Graduate | 33 Years |