![]() |
Error in query : Select project_type_tb.orderlist,project_plan.Budget_Year,project_plan.Project_plan,mis_ex_mcactivity.mc_title,Count(mis_ex_mcattend.attend_personId) as Nums From mis_ex_mcactivity Inner Join mis_ex_mcattend 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 project_plan.missId = mis_ex_mcproject.missID Inner Join project_type_tb On project_type_tb.projectId= project_plan.projectId Group By project_plan.Budget_Year, project_plan.Project_plan, mis_ex_mcactivity.mc_title Order by project_plan.missId ASC. Unknown column 'project_plan.missId' in 'on clause' |