how to reduce quantity (merged 2) [message #572869] |
Tue, 18 December 2012 06:01 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/3a1687909bef38ae52708aaee2039342?s=64&d=mm&r=g) |
pakpolic@gmail.com
Messages: 23 Registered: June 2012 Location: Peshawar
|
Junior Member |
|
|
how to reduce quantity from one table due to other table
for exple.
i have a purchase a shampo in 20 quantity
and then sale this shampo 2 quantity
so i want now there should be 18 quantity of shampo in purchase table automatically
Purchase table Sale tabel
Product Id Sale id
Product Name product name
Quantity Quantity
|
|
|
|
|
|
Re: i want to reduce quantity [message #572981 is a reply to message #572978] |
Wed, 19 December 2012 03:00 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
cookiemonster
Messages: 13925 Registered: September 2008 Location: Rainy Manchester
|
Senior Member |
|
|
If you really don't know how to write an update statement in oracle then I can only suggest you spend some time reading the documentation.
If you know how to write an update but aren't sure how to write the specific one you need then you need to give us more information about your tables. We can't write an update statement against tables we know nothing about.
|
|
|