×
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.
In some cases, row in tableA is matched up with multiple rows in tableB. DB2
can't just pick one for you, you have to tell it what to do.
BEST way to correct this issue is to enhance your join so it guarantees
one-to-one match on the join. This can be done by adding additional join
criteria (i.e. AND a.fieldB = b.fieldB).
However, you could HACK it by picking one of the joined rows by using an
aggregate function such as MAX,MIN,AVG, even SUM (although SUM rarely makes
sense).
BTW, for performance reasons, stick with the EXISTS and forget the COALESCE
in this case.
Elvis
Celebrating 11-Years of SQL Performance Excellence on IBM i, i5/OS and
OS/400
www.centerfieldtechnology.com
-----Original Message-----
Subject: Re: Newbie SQL problem with UPDATE - SQL0811
As an Amazon Associate we earn from qualifying purchases.
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.
midrange.com
