TYPE=VIEW query=select `jjlourens2`.`setup_insurer`.`pk_insurer` AS `pk_insurer`,`jjlourens2`.`setup_insurer`.`insName` AS `insName`,`jjlourens2`.`job`.`jbClaimNo` AS `jbClaimNo`,`jjlourens2`.`job_schedule`.`sheduleDate` AS `sheduleDate`,`jjlourens2`.`job_schedule`.`jobDone` AS `jobDone`,`jjlourens2`.`job_schedule`.`cancelled` AS `cancelled`,`jjlourens2`.`job`.`jbdate` AS `jbdate`,`jjlourens2`.`setup_plumber`.`pname` AS `pname`,`jjlourens2`.`job_type`.`tName` AS `tName`,`jjlourens2`.`setup_scheduletype`.`ActionName` AS `ActionName`,`jjlourens2`.`job_schedule`.`pk_schedule` AS `pk_schedule` from (((((`jjlourens2`.`job` join `jjlourens2`.`job_schedule` on((`jjlourens2`.`job`.`pk_job` = `jjlourens2`.`job_schedule`.`fk_job`))) join `jjlourens2`.`setup_insurer` on((`jjlourens2`.`setup_insurer`.`pk_insurer` = `jjlourens2`.`job`.`fk_insurer`))) join `jjlourens2`.`setup_plumber` on((`jjlourens2`.`setup_plumber`.`pk_plumber` = `jjlourens2`.`job_schedule`.`fk_plumber`))) join `jjlourens2`.`job_type` on((`jjlourens2`.`job_type`.`pk_jtype` = `jjlourens2`.`job_schedule`.`jobCat`))) join `jjlourens2`.`setup_scheduletype` on((`jjlourens2`.`setup_scheduletype`.`pkaction` = `jjlourens2`.`job_schedule`.`jobType`))) md5=28980448474cf24350224e7fa5492e6f 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 `setup_insurer`.`pk_insurer` AS `pk_insurer`,`setup_insurer`.`insName` AS `insName`,`job`.`jbClaimNo` AS `jbClaimNo`,`job_schedule`.`sheduleDate` AS `sheduleDate`,`job_schedule`.`jobDone` AS `jobDone`,`job_schedule`.`cancelled` AS `cancelled`,`job`.`jbdate` AS `jbdate`,`setup_plumber`.`pname` AS `pname`,`job_type`.`tName` AS `tName`,`setup_scheduletype`.`ActionName` AS `ActionName`,`job_schedule`.`pk_schedule` AS `pk_schedule` from (((((`job` join `job_schedule` on((`job`.`pk_job` = `job_schedule`.`fk_job`))) join `setup_insurer` on((`setup_insurer`.`pk_insurer` = `job`.`fk_insurer`))) join `setup_plumber` on((`setup_plumber`.`pk_plumber` = `job_schedule`.`fk_plumber`))) join `job_type` on((`job_type`.`pk_jtype` = `job_schedule`.`jobCat`))) join `setup_scheduletype` on((`setup_scheduletype`.`pkaction` = `job_schedule`.`jobType`)))