TYPE=VIEW
query=select `jjlourens2`.`setup_insurer`.`insName` AS `insName`,`jjlourens2`.`clientdetails`.`clSurname` AS `clSurname`,`jjlourens2`.`clientdetails`.`clName` AS `clName`,`jjlourens2`.`job`.`jbdate` AS `jbdate`,`jjlourens2`.`job`.`jbClaimNo` AS `jbClaimNo`,`jjlourens2`.`job`.`fkJobDone` AS `fkJobDone` from ((`jjlourens2`.`setup_insurer` join `jjlourens2`.`job` on((`jjlourens2`.`setup_insurer`.`pk_insurer` = `jjlourens2`.`job`.`fk_insurer`))) join `jjlourens2`.`clientdetails` on((`jjlourens2`.`clientdetails`.`pk_client` = `jjlourens2`.`job`.`fk_client`)))
md5=af36075ec6a787661b1986efe327496b
updatable=1
algorithm=0
definer_user=root
definer_host=localhost
suid=2
with_check_option=0
revision=1
timestamp=2012-10-30 15:10:11
create-version=1
source=SELECT
\nsetup_insurer.insName,
\nclientDetails.clSurname,
\nclientDetails.clName,
\njob.jbdate,
\njob.jbClaimNo,
\njob.fkJobDone
\nFROM
\nsetup_insurer
\nINNER JOIN job ON setup_insurer.pk_insurer = job.fk_insurer
\nINNER JOIN clientDetails ON clientDetails.pk_client = job.fk_client