MySql Inner Join with WHERE clause [closed]

Yes you are right. You have placed WHERE clause wrong. You can only use one WHERE clause in single query so try AND for multiple conditions like this:

 SELECT table1.f_id  FROM table1 
   INNER JOIN table2
     ON table2.f_id = table1.f_id
 WHERE table2.f_type="InProcess"
   AND f_com_id = '430'
   AND f_status="Submitted"