I've got an error saying that" 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 'FROM table_A INNER JOIN table_B ON table_A.name = table_B.name' at line 1 "
The sql query is :
$sql="UPDATE table_A SET table_A.quantity = table_A.quantity - table_B.quantity FROM table_A INNER JOIN table_B ON table_A.name = table_B.name WHERE table_B.status = 'APPROVED'"; Please help me out of this error. Thank you.
"INNER" should be "INNER JOIN"
I think you also have to take out "table_A" from "SET quantity"
$sql="UPDATE table_A SET quantity = table_A.quantity - table_B.quantity FROM table_A INNER JOIN table_B ON table_A.name = table_B.name WHERE table_B.status = 'APPROVED'"; 
You have syntax error.
Correct syntaxs for UPDATE with INNER JOIN:
UPDATE T1,T2 [INNER JOIN | LEFT JOIN] T1 ON T1.C1 = T2. C1 SET T1.C2 = T2.C2, T2.C3 = expr WHERE condition Query:
$sql="UPDATE table_A INNER JOIN table_B ON table_A.name = table_B.name SET table_A.quantity = table_A.quantity - table_B.quantity WHERE table_B.status = 'APPROVED'"; 
INNERinstead ofINNER JOINUPDATElike that inMySQL- see this question for the correct syntax: stackoverflow.com/questions/1262786/…MySql