TYPE=VIEW
query=select `d`.`No` AS `CNO`,`d`.`dur` AS `DUR`,`d`.`dur_type` AS `Durattion_D`,`d`.`interst` AS `INTN`,`d`.`Code` AS `Code` from `co-operativebank`.`reschem` `f` join `co-operativebank`.`reinv` `d` where (`d`.`No` = `f`.`NO`)
md5=76c5009b82b29f23de576921a57d12fd
updatable=0
algorithm=0
definer_user=root
definer_host=localhost
suid=2
with_check_option=0
timestamp=2019-07-10 16:23:10
create-version=1
source=SELECT D.NO AS CNO,D.dur AS DUR,dur_type as Durattion_D,D.interst AS INTN,Code FROM `RESCHEM` F,reinv D WHERE D.NO=F.NO
client_cs_name=utf8
connection_cl_name=utf8_general_ci
view_body_utf8=select `d`.`No` AS `CNO`,`d`.`dur` AS `DUR`,`d`.`dur_type` AS `Durattion_D`,`d`.`interst` AS `INTN`,`d`.`Code` AS `Code` from `co-operativebank`.`reschem` `f` join `co-operativebank`.`reinv` `d` where (`d`.`No` = `f`.`NO`)
