I have some Question and I hope the Title fits to it. Here is my Problem, I have 2 Tables.
receiving has 2 Important columns and that is
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
Now my target is to lessen the
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.
Seems wrong, Right? I hope someone enlighten me what code to be used.