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
