attached is a class for customerbean
i am getting some data at
connection = new ConnectionUtility().getConnection();
pstmt = [login to view URL](SELECT_SHOPCASH_DETIAILS_SUPER);
rs = [login to view URL]();
while ([login to view URL]())
{
ShopCash shop = new ShopCash();
[login to view URL]([login to view URL](1));
[login to view URL]([login to view URL](2));
[login to view URL]([login to view URL](3));
[login to view URL]([login to view URL](4));
[login to view URL]([login to view URL](5));
[login to view URL]([login to view URL](6));
[login to view URL](shop);
}
now i need to perform another sql statement and add the data to the list like
[login to view URL]([login to view URL](1));
and add the data to the list.
additionally i am wondering how the sql statement can be done so that the correct turnover will be with the correct shop later
the sql statement will be something like
SELECT SUM(paid_in) from sessions where shop_id=?????
????? (select all shop_ids and add correctly to existing list).