Can you help convert this join to where not exist?

[Kenln]

Hi,

I have this query that sort of works. If vw_Type is a linked table to MSSQL it works fine. If it is an MSSQL View I get an error saying the query must be updatable.

vw_Type should be a view not a table for various resons.

I would like to change this query

     UPDATE vw_Type 
     RIGHT JOIN tbl_Type_Local
          ON vw_Type.Pay_Type_ID = tbl_Type_Local.Type_ID
     SET tbl_Type_Local.[Delete] = True 
     WHERE (((vw_Type.Type_ID) Is Null))

from a join to something like

     UPDATE tbl_Type_Local
     SET tbl_Type_Local.[Delete] = True 
     WHERE (Type_ID not exist (Select Type_ID  From vw_Type))

But I'm weak on these types of queries and cannot get it to work.

Can someone help me with this?

I would appreciate it.

Thank you,