I'm guessing here, but it looks like you're trying to do something like
this
UPDATE Warehouse_Table
SET ccc_id =
(select ccc_id
from source_table
where table_id = warehouse_table.table_id)
where table_id in (select table_id from inserted)
That would update all the records in the warehouse table that have a
table_id that's in the inserted records and update them with the current
ccc_id from the source_table for that table_id
untested of course
hth,
ike
--
s. isaac dealey ^ new epoch
isn't it time for a change?
ph: 503.236.3691
http://onTap.riaforge.org/blog
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:296803
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
