TYPE=VIEW
query=select `jjlourens2`.`clientdetails`.`pk_client` AS `pk_client`,`jjlourens2`.`clientdetails`.`clSurname` AS `clSurname`,`jjlourens2`.`clientdetails`.`clName` AS `clName`,`jjlourens2`.`job`.`jbClaimNo` AS `jbClaimNo`,`jjlourens2`.`job_schedule`.`sheduleDate` AS `sheduleDate`,`jjlourens2`.`job_schedule`.`jobdescription` AS `jobdescription`,`jjlourens2`.`job_schedule`.`jobType` AS `jobType`,`jjlourens2`.`job`.`fk_insurer` AS `fk_insurer` from ((`jjlourens2`.`clientdetails` join `jjlourens2`.`job` on((`jjlourens2`.`clientdetails`.`pk_client` = `jjlourens2`.`job`.`fk_client`))) join `jjlourens2`.`job_schedule` on((`jjlourens2`.`job`.`pk_job` = `jjlourens2`.`job_schedule`.`fk_job`)))
md5=30097b9eb7d298ab69478a0dce541719
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 `clientdetails`.`pk_client` AS `pk_client`,`clientdetails`.`clSurname` AS `clSurname`,`clientdetails`.`clName` AS `clName`,`job`.`jbClaimNo` AS `jbClaimNo`,`job_schedule`.`sheduleDate` AS `sheduleDate`,`job_schedule`.`jobdescription` AS `jobdescription`,`job_schedule`.`jobType` AS `jobType`,`job`.`fk_insurer` AS `fk_insurer` from ((`clientdetails` join `job` on((`clientdetails`.`pk_client` = `job`.`fk_client`))) join `job_schedule` on((`job`.`pk_job` = `job_schedule`.`fk_job`)))