Re: [GENERAL] UPDATE and outer joins

2003-10-08 Thread Bruno Wolff III
On Wed, Oct 08, 2003 at 15:40:13 +0100, Harry Broomhall <[EMAIL PROTECTED]> wrote: > 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. > > > > > >

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 join > > on A and another table B

Re: [GENERAL] UPDATE and outer joins

2003-10-08 Thread Bruno Wolff III
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 join > on A and another table B. (This is trying to perform a numb

[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