I have 4 tables as stated below( table 1 is sunmary of other tables from other sources ) ı want to add new fields to table 1 as total of below table in order to compare the balances for correctness
you have to aggregate the three item tables and right join to table1 as follows:
RIGHT JOIN(Table1) //TotalsTable: LOAD 'Loan' as [BS item], SUM(Total_ loan_balance) as Total_Field RESIDENT TableLoan; // assumming you have loaded previously this table concatenate LOAD 'Cash' as [BS item], SUM(Total_ Cash_balance) as Total_ Total_Field RESIDENT TableCash; concatenate LOAD 'Securities ' as [BS item], SUM(Total_ security_balance) as Total_ Total_Field RESIDENT TableSecurities;
