|
Posted by lvpaul on 01/25/06 17:50
Hello !
I habe 2 Tables
Table1: Orders
Fields: Ordernr, Opieces
Table2: Calloffs
Ordernr, Cpieces
In Table1 ordernr is primary key.
In Table2 the same ordernr can exist often
My problem
If the sum(Cpieces) < Opieces:
I have to create a new virtual calloff
with Cpieces = opieces - sum(cpieces)
Its too high for me.
Please help
Best regards
aaapaul
Navigation:
[Reply to this message]
|