问带有多个CTE的SQL查询，但得到“错误:关系"t”不存在“

EN

WITH tmp AS (
        Select a.tx_id, a.txo_index, a.address,b.tx_in_id from txo as a 
        inner join txin as b ON (a.tx_id = b.tx_out_id and a.txo_index= b.tx_out_index)
        where a.tx_in_id = 0
    ),
    tmp2 AS
    (
    Select tmp.tx_id,tmp.txo_index,tmp.address,tmp.tx_in_id,b.value as value_next,c.epoch_no as consumed_epoch,c.date as consumed_date from tmp
    inner join txo as b ON 
        tmp.tx_in_id  = b.tx_id and 
        tmp.address = b.address
    inner join tx as c ON 
        tmp.tx_in_id = c.id
    )
    Update t 
    SET 
        t.tx_in_id = tmp2.tx_in_id, 
        t.value_next = tmp2.value_next, 
        t.consumed_epoch = tmp2.epoch_no,
        t.consumed_date = tmp2.date
    FROM txo as t
    inner join tmp2 ON
        t.tx_id = tmp2.tx_id and t.txo_index = tmp2.txo_index and t.address = tmp2.address
    where t.tx_in_id =0