TYPE=VIEW
query=select `d`.`date_open` AS `Date`,`a`.`Acc_No` AS `Acc_no`,concat(`a`.`initial`,\' \',`a`.`fname`,\' \',`a`.`mname`,\' \',`a`.`lname`) AS `Name`,`a`.`father_name` AS `Father_Name`,`d`.`amt` AS `Amt` from (`co-operativebank-mitrachak`.`j_a` `a` join `co-operativebank-mitrachak`.`deposit_acc` `d`) where ((`a`.`Acc_No` = `d`.`acc_no`) and (`d`.`acc_type` = \'sv\'))
md5=1f38f6c5f5ded31fe5627a6dcca1f098
updatable=0
algorithm=0
definer_user=root
definer_host=localhost
suid=1
with_check_option=0
timestamp=2019-05-30 04:21:35
create-version=1
source=select  `d`.`date_open`  AS  `Date` ,\n `a`.`Acc_No`  AS  `Acc_no` ,\nconcat(  `a`.`initial` ,  \' \',  `a`.`fname` ,  \' \',  `a`.`mname` ,  \' \',  `a`.`lname`  )  AS  `Name` ,\n `a`.`father_name`  AS  `Father_Name` ,\n `d`.`amt`  AS  `Amt`  from (  `co-operativebank-mitrachak`.`j_a`  `a`  join  `co-operativebank-mitrachak`.`deposit_acc`  `d`  ) where ( (  `a`.`Acc_No`  =  `d`.`acc_no`  ) and (  `d`.`acc_type`  =  \'sv\' ) )
client_cs_name=utf8
connection_cl_name=utf8_general_ci
view_body_utf8=select `d`.`date_open` AS `Date`,`a`.`Acc_No` AS `Acc_no`,concat(`a`.`initial`,\' \',`a`.`fname`,\' \',`a`.`mname`,\' \',`a`.`lname`) AS `Name`,`a`.`father_name` AS `Father_Name`,`d`.`amt` AS `Amt` from (`co-operativebank-mitrachak`.`j_a` `a` join `co-operativebank-mitrachak`.`deposit_acc` `d`) where ((`a`.`Acc_No` = `d`.`acc_no`) and (`d`.`acc_type` = \'sv\'))
