![]() |
Error in query : Select personal_tb.Teacher_code,project_plan.Budget_Year,Concat(prefix.prefixNameFull, personal_tb.Teacher_name,' ',personal_tb.Teacher_lastname) As name,Sum(mis_ex_mcactivity.eshours)as HrNums,mis_ex_mcactivity.mc_title From personal_tb Inner Join prefix On prefix.prefixId = personal_tb.First_name Inner Join mis_ex_mcattend On mis_ex_mcattend.attend_personId = personal_tb.Teacher_code Inner Join mis_ex_mcactivity On mis_ex_mcactivity.mc_actId = mis_ex_mcattend.mc_actId Inner Join mis_ex_mcproject On mis_ex_mcproject.proID = mis_ex_mcactivity.proID Inner Join project_plan On mis_ex_mcproject.missID = project_plan.missId Group By personal_tb.Teacher_code, project_plan.Budget_Year, Concat(prefix.prefixNameFull, personal_tb.Teacher_name), personal_tb.Teacher_lastname Order by personal_tb.Teacher_code ASC. Unknown column 'project_plan.missId' in 'on clause' |