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.
~~~~~~~~~~
Denise
~~~~~~~~~~