MySql Inner Join with WHERE clause

Question

Here is my code    SELECT table1 f id  FROM table1 WHERE table1 f com id    430  AND        table1 f status    Submitted    INNER JOIN table2  ON table2 f id   table1 f id  where table2 f type    InProcess    I need information from table1 as all the id associated with f com id as 430 and status as submitted and the type should be only in process which is stored in other table table2   f id is p key and f key in both the tables  But this giving me errors  I think I am placing the WHERE clause wrong  how to fix it       Error msg   1064 - You have an error in your SQL syntax  check the manual that corresponds to your MySQL server version for the right syntax to use near  INNER JOIN table2   ON table2 f id     at line 2

User · Answer

1  Change the INNER JOIN before the WHERE clause  2  You have two WHEREs which is not allowed   Try this      SELECT table1 f id FROM table1   INNER JOIN table2       ON  table2 f id   table1 f id AND table2 f type    InProcess       WHERE table1 f com id    430  AND table1 f status    Submitted

User · Answer

You could only write one where clause    SELECT table1 f id  FROM table1  INNER JOIN table2  ON table2 f id   table1 f id  where table1 f com id    430  AND        table1 f status    Submitted  AND table2 f type    InProcess

User · Answer

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

User · Answer

You are using two WHERE clauses but only one is allowed  Use it like this   SELECT table1 f id FROM table1 INNER JOIN table2 ON table2 f id   table1 f id WHERE   table1 f com id    430    AND table1 f status    Submitted    AND table2 f type    InProcess

[mysql] MySql Inner Join with WHERE clause

Examples related to mysql

Examples related to sql

Examples related to where-clause

Examples related to mysql-error-1064