oracle join or datastage lookups

[Anthony1200]

Hi,

I have 2 tables A and B that are almost equal but need to be combined

A.1 A.2 A.3 A.x1 A.x2
B.2 B.2 B.3 B.y1 B.y2

The result in table I needs to be:
I.1 I.2 I.3 I.x1 I.x2 I.y1 I.y2

Since not all values need to be in A or B, the x or y columms need to be NULL when there is no match on the key collums A1 .. A3 and B1 .. B3

DO I need to perform a double datastage lookup? or should I use an oracle query?

[chulett]

For whatever reason, your example is not making any sense to me this morning. However, sure seems like the join for something like this could be best done in the source query rather than via some complex lookup.

To discuss this more, seems to me that real examples with actual values, both source and result would be very helpful.