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 = '26' ORDER BY na.assessor_name ASC