This is untested, but yo might try:
update tback set ops_behind = select (count(t2.lotnumber)) from tback t1,
lotsched t2 WHERE t1.lotnumber = t2.lotnumber AND t2.cycle IS NOT NULL
AND t2.cycle < 95 AND t2.act_strt IS NULL
Jeffrey M. Watson wrote:
is there a way to update a column with a count value from another table?
something like
update tback set ops_behind = (count(t2.lotnumber) from tback t1,
lotsched t2 WHERE t1.lotnumber = t2.lotnumber AND t2.cycle IS NOT NULL
AND t2.cycle < 95 AND t2.act_strt IS NULL
?
(obviously the above did not work but that's the idea) Thanks :-/
Jeff Watson [EMAIL PROTECTED]
Tube Methods, Inc.
610-279-7700
