× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.


  1.  Home
  2. MIDRANGE-L
  3. January 2007

Re: SQl update with Sub Select

----- 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

As an Amazon Associate we earn from qualifying purchases.

This thread ...
Replies:
Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.