TYPE=VIEW
query=select `jjlourens2`.`job`.`jbClaimNo` AS `jbClaimNo`,`jjlourens2`.`job`.`userInCharge` AS `userInCharge`,`jjlourens2`.`setup_user`.`userName` AS `userName`,`jjlourens2`.`job`.`jbdate` AS `jbdate` from (`jjlourens2`.`job` join `jjlourens2`.`setup_user` on((`jjlourens2`.`job`.`userInCharge` = `jjlourens2`.`setup_user`.`pk_user`)))
md5=1bf8f24b895ad9d388dcc659ec509f61
updatable=1
algorithm=0
definer_user=root
definer_host=localhost
suid=1
with_check_option=0
revision=1
timestamp=2013-07-24 00:12:02
create-version=1
source=select `job`.`jbClaimNo` AS `jbClaimNo`,`job`.`userInCharge` AS `userInCharge`,`setup_user`.`userName` AS `userName`,`job`.`jbdate` AS `jbdate` from (`job` join `setup_user` on((`job`.`userInCharge` = `setup_user`.`pk_user`)))