Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2004

    Unanswered: multiple table updates

    please help, I am trying to do an update across multiple tables as so:

    update (
    select t.external_ref externalRef,
    t.external_time externalTime,
    sdb.completed completed
    from trades t,
    sdblayoffrelations sdb,
    orders o
    where (t.order_id = sdb.cash_order_id_1
    or t.order_id = sdb.cash_order_id_2
    or t.order_id = sdb.layoff_order_id)
    and sdb.cash_order_id_1 = 999999999999
    and o.order_id = t.order_id
    and t.trade_time >= o.market_time ) sdbTrades
    set sdbTrades.externalRef = 66666666

    and I get 'can not modify a column which maps to a non-key preserved table'

  2. #2
    Join Date
    Jan 2004
    Scottsdale, AZ
    Do you have access to Metalink? See Doc number: 1015219.4

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts