TYPE=VIEW query=select `jjlourens2`.`clientdetails`.`clSurname` AS `clSurname`,`jjlourens2`.`clientdetails`.`clName` AS `clName`,`jjlourens2`.`clientdetails`.`pk_client` AS `pk_client`,`jjlourens2`.`job`.`fk_client` AS `fk_client`,`jjlourens2`.`job`.`pk_job` AS `pk_job`,`jjlourens2`.`survey`.`fk_job` AS `fk_job` from ((`jjlourens2`.`clientdetails` join `jjlourens2`.`job` on((`jjlourens2`.`clientdetails`.`pk_client` = `jjlourens2`.`job`.`fk_client`))) join `jjlourens2`.`survey` on((`jjlourens2`.`job`.`pk_job` = `jjlourens2`.`survey`.`fk_job`))) md5=033541ba71b5fc4c79bde8c8e92524b1 updatable=1 algorithm=0 definer_user=root definer_host=localhost suid=1 with_check_option=0 revision=2 timestamp=2016-12-14 13:46:46 create-version=1 source=SELECT \nclientDetails.clSurname, \nclientDetails.clName, \nclientDetails.pk_client, \njob.fk_client, \njob.pk_job, \nsurvey.fk_job \nFROM \nclientDetails \nINNER JOIN job ON clientDetails.pk_client = job.fk_client \nINNER JOIN survey ON job.pk_job = survey.fk_job