Ora 00933 error

[522369]

ora 00933 error arrived while executing these query

select Hr_department_name,milestone_name,Discription,active_flag from xxpa_project_milestones 
where hr_sm_department_mst.department_Id= xxpa_project_milestones.department_Id groupBy department_id;

I have Two table hr_sm_departmen t_mst consist of table name and another one xxpa_project_mi lestones which doesnt consist departmentName i have to make join but it shows me these error so can any one sort me out from these error whats wrong with the Query

[Rabbit]

There are a few problems.

Your active_flag field has a space in there. Your group by clause has no space. You refer to a table/view named hr_sm_departmen t_mst that is not in your from clause.