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`,`jjlourens2`.`survey`.`comments` AS `comments`,`jjlourens2`.`survey`.`q3RateService` AS `q3RateService` 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=95e048a2255d14a93966139e4f1cfe42
updatable=1
algorithm=0
definer_user=root
definer_host=localhost
suid=1
with_check_option=0
revision=3
timestamp=2016-12-14 13:46:52
create-version=1
source=SELECT
\nclientDetails.clSurname,
\nclientDetails.clName,
\nclientDetails.pk_client,
\njob.fk_client,
\njob.pk_job,
\nsurvey.fk_job,
\nsurvey.comments,
\nsurvey.q3RateService
\nFROM
\nclientDetails
\nINNER JOIN job ON clientDetails.pk_client = job.fk_client
\nINNER JOIN survey ON job.pk_job = survey.fk_job