Concatenation of two fileds

[pavanthota]

Hi

I have two tables below like this

Table1:

Load

a,

b,

c,

d

From   ;

Table2:

Load

a,

e,

f,

g

From ;

I need to satisfy the below condition and get the final table like this

Finaltable:

Load

a,

b,

e&c as c,

d

From

where a=a;

Can any one please help me

[hic · Accepted solution]

Table1:

Load a, b, c, d From ...  ;

Join

Load a, e, f, g From ...  ;

Finaltable:

Load a, b, e&c as c, d

From ... where a= ...;

Drop Table Table1 ;