|Subject||RE: [firebird-support] Re: Multiple table update question|
> If your suggestion works, then it's simpler than the way IAs it did not work, I am going to try your solution.
> normally do things. I'm used to writing
However, I have a question regarding the sql
> UPDATE table1 T1Is the where exist statement correct, or is there a typo?
> SET T1.field2 = (select T2.field2 FROM table2 T2
> where T2.field1 = T1.field1) where
> exists(select * from table2 T3
> where T3.field1 = T2.field1)
The other issue is that my Table1.Field2 is defined as NOT NULL, so I think
this may not work for me.
I can believe that such a simple sql is causing me this prbs :-(
Thanks Svein, Ann, Helen and Norman for your help.