Joining same table & update query

[kaushal]

Demo Table: orders
orderid amount disc_amt actual_amount
1000 500 100 500
2000 600 200 600
3000 400 200 400

Now I am having a requirement that to update actual_amount of each order that is subtracted by disc_amt.

I want to know what should be the update query?

Please Help.

Thanks
Kaushal.

[james438]

If I am understanding you correctly you want to update your orders table so that the actual_amout reads actual_amount - disc_amt.

Try this:


UPDATE orders SET actual_amount=(actual_amount - disc_amt)

This will update all of the rows in your orders table changing the actual_amount to actual_amount minus disc_amt.

[kaushal]

Wow James what a magic...
You are awesome.
Thank you for helping me.
Thanks again.