<div>
You have to Join the two tables first , so we need to know what is your joint field , &nbsp;if you can please post the schema for the two tables and just provide an example for what you want to do exactly &nbsp;
</div>


You have to Join the two tables first , so we need to know what is your joint field ,  if you can please post the schema for the two tables and just provide an example for what you want to do exactly  

<div>
update product,sale set produt = ( product.ProductQuantity - sale.quantity)<br />
<br />
<br />
I try like this but it not work
</div>


update product,sale set produt = ( product.ProductQuantity - sale.quantity)


I try like this but it not work

<div>
So you have two tables one called products &nbsp;and it has a field called produt &nbsp;and another once called &nbsp;ProductQuantity<br />
<br />
and you have another table called sales and it has a filed called produt &nbsp;and another filed called quantity<br />
<br />
is that true ? 
</div>


So you have two tables one called products  and it has a field called produt  and another once called  ProductQuantity

and you have another table called sales and it has a filed called produt  and another filed called quantity

is that true ?

<div>
<div class="content wysiwyg-content">
I have 2 tables table 'product' and &nbsp;'sale' &nbsp;how can I write sql statement to deduct sale item from table product
</div>
</div>


I have 2 tables table 'product' and  'sale'  how can I write sql statement to deduct sale item from table product

Mysql sate ment deduct onetable from another table

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.

MySQL Server

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.