Hi,

I am trying to use a join to update a table concatenating some fields together.

update TABLEA set STATUS = (b.TRANSACTION_ ID||'Last TRANS was '||b.change_rea son_code ||' - ' ||b.master_tran saction_status)
where nat_supp_point_ text in (select a.nat_supp_poin t_text from TABLEA a, TABLEB b
where a.nat_supp_poin t_text = b.nat_supp_poin t_text
and transaction_id in (select max(transaction _id) from...