[GENERAL] UPDATE and outer joins

2003-10-08 Thread Harry Broomhall
I wonder if anybody could give me a few pointers on a problem I face. I need to do an UPDATE on table A, from an effective left outer join on A and another table B. (This is trying to perform a number translation, where the items that need it are rare.) The following points *I think* ar

Re: [GENERAL] UPDATE and outer joins

2003-10-08 Thread Harry Broomhall
Bruno Wolff III writes: > On Wed, Oct 08, 2003 at 12:23:04 +0100, > Harry Broomhall <[EMAIL PROTECTED]> wrote: > >I wonder if anybody could give me a few pointers on a problem I face. > > > >I need to do an UPDATE on table A, from an effective left outer j