Hi guys! Hopefully quick question here.

I have a table, we'll call it primary, and another called (you guessed it :) ) secondary. What I really want to do is:

select primary
replace approved with .f. for all encumb_id in ;
     (select encumb_id from secondary where noapp = .f.)

But I seem to remember that I can't do a replace using an "in" or perhaps it was that you can't use the results of secondary select or something like that.

I was figuring I'd just use a loop. I know that will work. But I wanted to doublecheck this understanding I have because I would have thought the SQL would be faster. That is, if I'm wrong and this can be done. So am I just missing something small or what?

Thanks in advance.