[[Västgöta/veckomamil]] == Rödback == {{{sqlite3 UPDATE acquisitions SET amount = amount - 60 WHERE id = 299; UPDATE money SET amount = amount + 60 * 250 WHERE id = 3; UPDATE stock SET active = active - 60 WHERE product_id = 146; }}} | Stock | Money | Acquisitions | |--------|----------|--------------| | Before | | | | 240 | -1010.00 | 265 | |--------|----------|--------------| | After | | | | 180 | -860.00 | 205 |