TYPE=VIEW
query=select `jjlourens2`.`job`.`pk_job` AS `pk_job`,`jjlourens2`.`job`.`jbClaimNo` AS `jbClaimNo`,`jjlourens2`.`job`.`jbRefVal` AS `jbRefVal`,`jjlourens2`.`job`.`fk_insurer` AS `fk_insurer`,`jjlourens2`.`job`.`fk_client` AS `fk_client`,`jjlourens2`.`job`.`jbdate` AS `jbdate`,`jjlourens2`.`job_schedule`.`pk_schedule` AS `pk_schedule`,`jjlourens2`.`job_schedule`.`sheduleDate` AS `sheduleDate`,`jjlourens2`.`job_schedule`.`fk_job` AS `fk_job`,`jjlourens2`.`job_schedule`.`jobCat` AS `jobCat`,`jjlourens2`.`job_type`.`pk_jtype` AS `pk_jtype`,`jjlourens2`.`job_type`.`tName` AS `tName`,`jjlourens2`.`job`.`jobActive` AS `jobActive` from ((`jjlourens2`.`job` left join `jjlourens2`.`job_schedule` on((`jjlourens2`.`job_schedule`.`fk_job` = `jjlourens2`.`job`.`pk_job`))) left join `jjlourens2`.`job_type` on((`jjlourens2`.`job_type`.`pk_jtype` = `jjlourens2`.`job_schedule`.`jobCat`))) group by `jjlourens2`.`job`.`pk_job`
md5=003beca5be17111410dfd9929dd42c3c
updatable=0
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`.`pk_job` AS `pk_job`,`job`.`jbClaimNo` AS `jbClaimNo`,`job`.`jbRefVal` AS `jbRefVal`,`job`.`fk_insurer` AS `fk_insurer`,`job`.`fk_client` AS `fk_client`,`job`.`jbdate` AS `jbdate`,`job_schedule`.`pk_schedule` AS `pk_schedule`,`job_schedule`.`sheduleDate` AS `sheduleDate`,`job_schedule`.`fk_job` AS `fk_job`,`job_schedule`.`jobCat` AS `jobCat`,`job_type`.`pk_jtype` AS `pk_jtype`,`job_type`.`tName` AS `tName`,`job`.`jobActive` AS `jobActive` from ((`job` left join `job_schedule` on((`job_schedule`.`fk_job` = `job`.`pk_job`))) left join `job_type` on((`job_type`.`pk_jtype` = `job_schedule`.`jobCat`))) group by `job`.`pk_job`