TYPE=VIEW
query=select `jjlourens2`.`setup_insurer`.`insName` AS `insName` from (((`jjlourens2`.`setup_insurer` join `jjlourens2`.`job` on((`jjlourens2`.`setup_insurer`.`pk_insurer` = `jjlourens2`.`job`.`fk_insurer`))) join `jjlourens2`.`job_schedule` on((`jjlourens2`.`job`.`pk_job` = `jjlourens2`.`job_schedule`.`fk_job`))) join `jjlourens2`.`setup_acttype` on((`jjlourens2`.`setup_acttype`.`pkactType` = `jjlourens2`.`job_schedule`.`jobType`)))
md5=b2254c54c2319bfdfe97bbe3aadb4a27
updatable=1
algorithm=0
definer_user=root
definer_host=localhost
suid=2
with_check_option=0
revision=1
timestamp=2013-06-28 00:20:39
create-version=1
source=SELECT
\nsetup_insurer.insName
\nFROM
\nsetup_insurer
\nINNER JOIN job ON setup_insurer.pk_insurer = job.fk_insurer
\nINNER JOIN job_schedule ON job.pk_job = job_schedule.fk_job
\nINNER JOIN setup_actType ON setup_actType.pkactType = job_schedule.jobType