sql - Update query "updatable query" issue -

In Entrance 2003, I am trying to get a table and if there is an indicator for any given line of given ID = 1,

  ID indicator Jack 0 Jack 0 Jeff 1 Jeff Mark 1 mark 1  

will be:

Icon indicator Jack 0 Jack 1 Jeff 1 Mark 1 Mark 1

Since Jeff and Mark both have at least 1 line with indicator = 1, I I want to make all your lines = 1.

This is my endeavor, but I need an error "Operation should use an updateable query" (I think because the selection statement table is not ... you do not update a query Update Table 1: Join the Inner (Table 1) Table 1. ID 1 from where ((Table 1. Indicator) = 1))) Table 1.ID on list = List. ID set table 1. Indicator = 1;

What is a good way to quickly and efficiently create a temporary table ? Or will a floating table be the best / most efficient solution? This will make my database a little bit weird because the 8 lines I have to do this ... The table I'm opperating is ~ 300 MB.

Thanks

There is a way to do this:

  Update T1 SET Indicator = 1 where indicator = 0 and current (choose from * T1 AS T2 WHERE T2.Indicator = 1 and T1.ID = T2.ID)