Hi,I create a view with 2 joined tables:with cte as (select DataID, Name,SubType, FileType,MimeType,VersionID,Version from dtree A1, dversdata A2 where A1.dataid=A2.Docid And A1.Subtype='144'AND A2.mimetype='application/news-message-id')update cte set MimeType = 'application/x-outlook-msg', Subtype=749
what I want to do is to update two columns. Both are from different tables and I get an error.....Has anybody an idea how I can do it?Kind regards,Lara