|
midrange.com
select * from tbluserpt
1....+....2....+....3....+....4....+....5....+.
OBOPRCE IFOTH OBDIV OBCLS
15.50000 15.50000 3 3
.00000 15.50000 1 1
.00000 15.50000 2 2
select * from tblusrp
....+....1....+....2....+....3....
OBDIV OBCLS OKMARK
1 1 3.00000
3 3 4.00000
update tbluserpt
set tbluserpt.oboprce=
(select tbluserpt.ifoth / (1 - tblusrp.okmark)
from tblusrp
where (tbluserpt.obdiv=tblusrp.obdiv and
tbluserpt.obcls=tblusrp.obcls))
where tbluserpt.oboprce = 0
and (tbluserpt.obdiv, tbluserpt.obcls) in
(select tbluserpt.obdiv, tbluserpt.obcls
from tbluserpt inner join tblusrp
using (obdiv, obcls))
1 rows updated in TBLUSERPT in QTEMP.
select * from tbluserpt
1....+....2....+....3....+....4....+....5....+.
OBOPRCE IFOTH OBDIV OBCLS
15.50000 15.50000 3 3
7.75000- 15.50000 1 1
.00000 15.50000 2 2
Rob Berendt
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.
