Posts by Alcioles • 1 point
2 posts
-
0
votes1
answer22
viewsA: Column update of a table with data from another table
worked, demoted a little /* Connection with 127.0.0.1 closed on 2018-07-26 01:49:45 / / Affected records: 7,344 Records found: 0 Notices: 0 Duration of 1 consultation: 00:09:11 / / Connecting to…
sql-updateanswered Alcioles 1 -
0
votes1
answer22
viewsQ: Column update of a table with data from another table
how can I perform this update? update estoque,tabcest set estoque.cest=tabcest.cest where locate(trim(tabcest.ncm),estoque.ncm) and estoque.tipoproduto in ('produto','consumo') and estoque.cest is…
sql-updateasked Alcioles 1