select sum(p1),sum(p2),sum(p3); from bank where id='E' and clientid=apprid into table exp select bank set filter to bank.itemtype='E' and bank.clientid=apprid go topand here is the code on my view
select * ; from mainbase!bank; where bank.id=("E"); and bank.clientid=(apprid)So i have this table named bank and i select what i want based on the ID of the client an the Item type which has to be E.