TYPE=VIEW
query=select `jjlourens2`.`job`.`jbdate` AS `jbdate`,`jjlourens2`.`job`.`fk_insurer` AS `fk_insurer`,`jjlourens2`.`job`.`jbClaimNo` AS `jbClaimNo` from (`jjlourens2`.`job` join `jjlourens2`.`setup_insurer` on((`jjlourens2`.`setup_insurer`.`pk_insurer` = `jjlourens2`.`job`.`fk_insurer`)))
md5=b634e8eb9a70881275c4ec2bd0337d96
updatable=1
algorithm=0
definer_user=root
definer_host=localhost
suid=2
with_check_option=0
revision=1
timestamp=2012-08-01 08:58:11
create-version=1
source=SELECT
\njob.jbdate,
\njob.fk_insurer,
\njob.jbClaimNo
\nFROM
\njob
\nINNER JOIN setup_insurer ON setup_insurer.pk_insurer = job.fk_insurer