t2.valueFrom: Joe Pluta
SELECT t1.id, t1.type, COALESCE(t2.value, t1.value)
FROM t1 LEFT OUTER JOIN t2 ON t1.id = t2.id and t1.type = t2.type
That ought to do the trick. Basically, if there is a row in T2,
used.will be used. Otherwise, t2.value will be NULL and t1.value will be
Nothing against Michael's UNION technique, either, this technique just
a little more straightforward to me. But that's the thing about SQL;there
are often several ways to do the same thing, and the performance of each
technique may be influenced by the data in the files.
This is the Java Programming on and around the iSeries / AS400
(JAVA400-L) mailing list
To post a message email: JAVA400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
or email: JAVA400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
As an Amazon Associate we earn from qualifying purchases.
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.