Dear Sir,
Please Confirm how mutch table in mention query
SELECT EMP_NUM,emp_name,grade_code+grade_level as Grade,i.dept_cd
FROM intranet_users i,estt_emp_mast e
inner join cms.dbo.hod_dept b on e.empno=b.hod_no,
dept_codes d
where i.emp_num=e.empno and i.dept_cd=d.dept_code and emp_num = '" + UserName.Text.Trim() + "' and pwd = '" + _respassword.ToString().Trim() + "'
group by EMP_NUM,emp_name,grade_code+grade_level,i.dept_cd