TYPE=VIEW
query=select `jjlourens2`.`clientdetails`.`pk_client` AS `pk_client`,`jjlourens2`.`job`.`jbClaimNo` AS `jbClaimNo`,`jjlourens2`.`job`.`jbRefVal` AS `jbRefVal`,`jjlourens2`.`clientdetails`.`clDateJoin` AS `clDateJoin`,`jjlourens2`.`clientdetails`.`clSurname` AS `clSurname`,`jjlourens2`.`clientdetails`.`clTel1` AS `clTel1`,`jjlourens2`.`clientdetails`.`clTel2` AS `clTel2`,`jjlourens2`.`clientdetails`.`clTel3` AS `clTel3`,`jjlourens2`.`clientdetails`.`clName` AS `clName`,`jjlourens2`.`clientdetails`.`clPostal` AS `clPostal`,`jjlourens2`.`setup_postal_codes`.`suburb` AS `suburb`,`jjlourens2`.`setup_postal_codes`.`town` AS `town`,`jjlourens2`.`job`.`jbdate` AS `jbdate`,`jjlourens2`.`job`.`pk_job` AS `pk_job` from ((`jjlourens2`.`clientdetails` left join `jjlourens2`.`job` on((`jjlourens2`.`clientdetails`.`pk_client` = `jjlourens2`.`job`.`fk_client`))) join `jjlourens2`.`setup_postal_codes` on((`jjlourens2`.`setup_postal_codes`.`pk_postal` = `jjlourens2`.`clientdetails`.`fk_postal`)))
md5=a7ddee08731492f0d746de47c341f4f5
updatable=0
algorithm=0
definer_user=root
definer_host=localhost
suid=1
with_check_option=0
revision=1
timestamp=2012-03-02 23:11:04
create-version=1
source=select `clientdetails`.`pk_client` AS `pk_client`,`job`.`jbClaimNo` AS `jbClaimNo`,`job`.`jbRefVal` AS `jbRefVal`,`clientdetails`.`clDateJoin` AS `clDateJoin`,`clientdetails`.`clSurname` AS `clSurname`,`clientdetails`.`clTel1` AS `clTel1`,`clientdetails`.`clTel2` AS `clTel2`,`clientdetails`.`clTel3` AS `clTel3`,`clientdetails`.`clName` AS `clName`,`clientdetails`.`clPostal` AS `clPostal`,`setup_postal_codes`.`suburb` AS `suburb`,`setup_postal_codes`.`town` AS `town`,`job`.`jbdate` AS `jbdate`,`job`.`pk_job` AS `pk_job` from ((`clientdetails` left join `job` on((`clientdetails`.`pk_client` = `job`.`fk_client`))) join `setup_postal_codes` on((`setup_postal_codes`.`pk_postal` = `clientdetails`.`fk_postal`)))