From: Michael_Schutte@xxxxxxxxxxxxwanted records from both
You are right Joe...
I went the route of union because I assumed Ash
tables. From what I can see, if you join the twotables, you will miss
the records that are unique in the joined table.you join table 2 to
So if table 1 has 1 record and table 2 has 3. And
table 1, your result will only be 1 record.
Absolutely right, Michael. Yet another reason why
programming is less about
the language and more about succinctly defining the
business problem! If
there are records in T2 that are not overriding
records in T1, then those
records will not be included in a LEFT OUTER JOIN
(that's the underlying
feature of a JOIN: the primary file drives the data
My assumption is that all id/type combinations in T2
are also in T1, your
assumption is that they may not be. The technique
chosen will probably rely
on the data (although if the answer is not known,
your solution gets the nod
because it handles both cases).
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
As an Amazon Associate we earn from qualifying purchases.
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.