Re: Simple update query from joined tables

But of course. It's been awhile since I used this line in my init.ora file:

worka_lika_MS = true; ;-)

Tom

Tim C wrote:

> Thanks Tom, I saw it. Check my response.
>
> What I have discovered since is that I'm very used to an extension that
> Microsoft has to their implementation of the UPDATE statement: the ability
> to do just what I want.
>
> In a nutshell: You can use a select to join any tables you wish & then use
> that result as a data source to do a keyed update any other table - as long
> as the key is specified in the result you built. Very handy.
Received on Fri Aug 02 2002 - 12:39:28 CDT