At two different tables, The new value of [chargeINFO.u_chargewait] I want to add and save the existing [userinfo.u_charged] value. After the query operation, I want the value of [u_charged] to be saved as 150000.
I can't find it even if I search for the query statement. Please help me. Thank you.
$query = "UPDATE userinfo
INNER JOIN chargeINFO ON (userinfo.u_id = chargeINFO.u_id)
SET userinfo.u_charged = chargeINFO.u_chargewait";