If Table_A and Table_B are not related, then how do you aim to join it to created Table_C? There must be some unique and common column in both the entities.

SQL is the hardest part of programming. You should really focus on that before trying to be creative. There is probably an easier way of doing the same and it will depend on the problem you have.

Table_A , Table_B and Table_C.(I want to create table)

How can I create Table_C.

Please check my picture below

How can I achieve this .Please help me.

Hi,

Please follow the below steps,

1. Create Output structure like Table C

2. Use Advanced SQL widget and refer below query,

insert into Table_C select sum(T.A1),sum(T.A2),sum(T.A3),sum(T.Count_A),sum(T.B1),sum(T.B2),sum(T.B3),sum(T.Count_B) from ( select COUNT(A1) as A1,COUNT(A2) as A2,COUNT(A3) as A3,COUNT(A1)+COUNT(A2)+COUNT(A3) as Count_A, 0 as B1,0 as B2,0 as B3,0 as Count_B from Table_A union all select 0 as A1,0 as A2,0 as A3,0 as Count_A,COUNT(B1) as B1,COUNT(B2) as B2,COUNT(B3) as B3,COUNT(B1)*COUNT(B2)*COUNT(B3) as Count_B from Table_B ) as T