(A concatenate B) Join (C concatenate D)

[penkerton]

Dears,

need your help.

Please let me know on how to script the following:

(TableA concatenate TableB) Join (TableC concatenate TableD)

In Discussions found only (TableA concatenate TableB) Join TableC, and still can't figure out how to script my request...

Kind regards,

Yury.

[vishsaggi · Accepted solution]

Try below:

TabA:

LOAD * INLINE [

A, B

1, 3

2,4

];

TabB:

LOAD * INLINE [

A, B

3, 4

4, 5

];

TabC:

LOAD * INLINE [

C, D

1, 3

2,4

];

TabD:

LOAD * INLINE [

C, D

1, 3

2,4

];

Left Join(TabA)

Final:

LOAD *

Resident TabC;

Drop Table TabC;

[kfoudhaily]

create 2 temp tables E and F where you have the concatenation of each tables couples

then E left join F