Loading the field in to final table

[pavanthota]

Hi,

I have two tables like this

Table1:

Load

a,

b,

c

from  ;

Table 2:

e,

f,

g

from ;

In final table i need these fields like below

finaltable:

load

a,

b,

c,

e

from   ;

can any one help on this scenario

[#2]

Hi Pavan,

     Can you elaborate the problem you are facing? I'm not sure what you are trying to do.

finaltable:

load

a,

b,

c

from ;

concantenate

load

e

from ;

Or you can try this

finaltable:

load

a,

b,

c

from ;

join

load

e

from ;