how to reduce quantity (merged 2) [message #572869] |
Tue, 18 December 2012 06:01 |
|
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 |
cookiemonster
Messages: 13938 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.
|
|
|