SELECT * ,emp.emp_ref_id as emp_code FROM erp_emp as emp 
                     LEFT JOIN erp_users AS usr on usr.user_ref_id = emp.emp_ref_id
                     LEFT JOIN erp_emp_qualification AS qualification on qualification.emp_ref_id = emp.emp_ref_id
                     LEFT JOIN erp_emp_banks as banks on banks.emp_ref_id = emp.emp_ref_id
                     LEFT JOIN erp_emp_job_profile as profile on profile.emp_ref_id = emp.emp_ref_id 
                     LEFT JOIN erp_mas_designation as deg on deg.dg_ref_code = profile.emp_job_position 
                     LEFT JOIN erp_mas_departments as dep on dep.dp_ref_code = profile.emp_department 
                     WHERE usr.user_is_deleted='no' AND emp.emp_isdeleted ='0'