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`)))