1.  CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `balanceview`  AS
2.  select `users`.`login` AS `login`,`members`.`totalAmount` AS `totalAmount`, `mem-bers`.`groupID` AS `groupID`
3.  from (`users` join `members`)
4.  where ((`users`.`userID` = `members`.`userID`)  and (`members`.`status` = 'ACCEPTED')) ;