UPDATE All_Names SET Item_Count = v2.IdCount +
FROM All_Names T1, IdCountM v2 WHERE T1.IdNum = v2.IdNum
works for me.
Regards,
Alastair.
----- Original Message -----
From: "Jeffrey M. Watson" <[EMAIL PROTECTED]>
To: "RBASE-L Mailing List" <[email protected]>
Sent: Wednesday, February 13, 2008 6:57 PM
Subject: [RBASE-L] - update
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
--
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.5.516 / Virus Database: 269.20.4/1275 - Release Date: 12/02/2008
15:20
