Combine 2 result set

[RKULKARNI4]

Hello Team

I need to combine both result1 and result2 and create another table called finalresult.How the approach can be done.Please advise

Please refer below 

Result1:

Load 

field1,

field2

from tab1

qvd;

Result2:

Load 

field1,

field2

from tab2

qvd;

[marinadorcassio1]

Hi, just by using concatenate...?

[RKULKARNI4]

Hi All ,

I have set the audit table 

I need to find the 

Tab                     No of rows 

Result1                  100 

Result2                   50

How i can find out please help me out.

Regards

RK

[Chanty4u]

can you share sample with expected output?