Sql statement required for copy txt from one table filed to another table field

Hi to all,


I wanted to copy some data from one table field to another table field. (php/mysql) by using sql statement

There are 2 tables named Inventory & Purchase

Inventory table fields -
Model No, Model Name, Qty

Purchase table fields –
Model No, Model Name, Qty


If I add 5 in Qty field of Purchase table
It should add 5 qty to Qty (inventory table)

I just need simple sql statement for this


Thanks in advance

Narayan

 

You could do something like this:

Thats probably not exactly what you want and its probably easier just to do those extra inserts/updates.