TYPE=VIEW
query=select `jjlourens2`.`job`.`jbClaimNo` AS `jbClaimNo`,`jjlourens2`.`job`.`userInCharge` AS `userInCharge`,`jjlourens2`.`setup_user`.`userName` AS `userName` from (`jjlourens2`.`job` join `jjlourens2`.`setup_user` on((`jjlourens2`.`job`.`userInCharge` = `jjlourens2`.`setup_user`.`pk_user`)))
md5=399591b04d9809d68d7046dc407e0b00
updatable=1
algorithm=0
definer_user=root
definer_host=localhost
suid=2
with_check_option=0
revision=1
timestamp=2013-02-23 10:02:09
create-version=1
source=SELECT
\njob.jbClaimNo,
\njob.userInCharge,
\nsetup_user.userName
\nFROM
\njob
\nINNER JOIN setup_user ON job.userInCharge = setup_user.pk_user