Re: SQl update with Sub Select

["Joe D" <nike@xxxxxxxxxxxxxx>]

----- Original Message ----- 
From: "BirgittaHauser" <Hauser@xxxxxxxxxxxxxxx>
If you are already on release V5R4 the following syntax should work:
UPDATE phdmass01/STCHSP
  SET R9CEAA = 'N'
  WHERE (r9nmid, Field2, Field3, ... FieldN) in (SELECT (r9nmid, Field2x,
Field3x ... FieldNx)
                                                    from union/phdmassd)

Wow....

Thanks Birgitta!

I did not realize you could use the IN subselect coded like that.  In the 
past I have always concatenated the fields on both sides to do the 
comparison.  This looks a LOT cleaner.  I am guessing it should also be 
faster if appropriate logicals exist for the subselected fields.

JD