Computation from 2 Tables turns to be Negative

Good Morning.

I have some Question and I hope the Title fits to it. Here is my Problem, I have 2 Tables.

Table Receiving

Computation from 2 Tables turns to be Negative

Table receiving has 2 Important columns and that is QtyPack and QtyStan and Please take note that QtyPack is a whole number and QtyStan is Must be divided to 100 before proceeding into a MySQL update command.

and this the Table 2

Table purchorder

Computation from 2 Tables turns to be Negative

Now my target is to lessen the QtyPack and QtyStan with a \ 100 into ReflectedQty and I use this code.

update receiving r join purchorder p on P.RInumber = r.RINo set p.ReflectedQty = Format(p.ReflectedQty - r.QtyPack - (r.QtyStan / 100),2) where RINumber = myvalue

and the output is this.

Computation from 2 Tables turns to be Negative

Seems wrong, Right? I hope someone enlighten me what code to be used.

TYSM

Replay

Category: mysql Time: 2016-07-29 Views: 3
Tags: mysql

Related post

iOS development

Android development

Python development

JAVA development

Development language

PHP development

Ruby development

search

Front-end development

Database

development tools

Open Platform

Javascript development

.NET development

cloud computing

server

Copyright (C) avrocks.com, All Rights Reserved.

processed in 0.146 (s). 12 q(s)