topic Loading the field in to final table in Water Cooler

Loading the field in to final table

pavanthota — Fri, 04 May 2012 07:46:10 GMT

Hi,

I have two tables like this

Table1:

Load

from ;

Table 2:

from ;

In final table i need these fields like below

finaltable:

load

from ;

can any one help on this scenario

Fri, 04 May 2012 07:56:21 GMT

Hi Pavan,

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

finaltable:

load

from ;

concantenate

load

from ;

Or you can try this

finaltable:

load

from ;

join

load

from ;