MYSQL alias on LEFT join table error -
can't find table declared on left join using alias. here's query:
"insert currentweekvalue (symbol,value) select * from(select cwv.symbol csymbol, (cwv.value + di.value) totval currentweekvalue cwv left join $dayiterated di on cwv.symbol = di.symbol) cmbtbl cmbtbl.csymbol = cmbtbl.di.symbol on duplicate key update value = values(cmbtbl.totval)";
i've encountered unknown column 'cmbtbl.di.symbol' in 'where clause'. how solve problem. thanks
Comments
Post a Comment