/ Published in: SQL
Expand |
Embed | Plain Text
Copy this code and paste it in your HTML
UPDATE asset_class_allocations SET to_date = '2011-07-01' FROM asset_allocation aa JOIN options o ON aa.option_uid = o.uid JOIN product p ON o.product_uid = p.uid WHERE p.product_id IN (817,617) AND asset_class_allocations.to_date = '2011-06-30' AND asset_class_allocations.allocation_uid = aa.uid;