TYPE=VIEW
query=select `jjlourens2`.`setup_plumber`.`pname` AS `pname`,`jjlourens2`.`setup_plumber`.`pk_plumber` AS `pk_plumber`,`jjlourens2`.`job`.`pk_job` AS `pk_job`,`jjlourens2`.`job`.`fk_client` AS `fk_client`,`jjlourens2`.`job_schedule`.`pk_schedule` AS `pk_schedule`,`jjlourens2`.`job_schedule`.`sheduleDate` AS `sheduleDate`,`jjlourens2`.`job_schedule`.`timeStart` AS `timeStart`,`jjlourens2`.`job_schedule`.`timeFinish` AS `timeFinish`,`jjlourens2`.`job_schedule`.`cancelled` AS `cancelled`,`jjlourens2`.`job_schedule`.`jobdescription` AS `jobdescription`,`jjlourens2`.`clientdetails`.`pk_client` AS `pk_client`,`jjlourens2`.`clientdetails`.`clSurname` AS `clSurname`,`jjlourens2`.`clientdetails`.`clName` AS `clName`,`jjlourens2`.`clientdetails`.`clTel1` AS `clTel1`,`jjlourens2`.`clientdetails`.`clTel2` AS `clTel2`,`jjlourens2`.`clientdetails`.`clPostal` AS `clPostal`,`jjlourens2`.`clientdetails`.`fk_postal` AS `fk_postal`,`jjlourens2`.`setup_postal_codes`.`pk_postal` AS `pk_postal`,`jjlourens2`.`setup_postal_codes`.`suburb` AS `suburb`,`jjlourens2`.`setup_postal_codes`.`postalcd` AS `postalcd`,`jjlourens2`.`clientdetails`.`clTel3` AS `clTel3`,`jjlourens2`.`clientdetails`.`clEmail` AS `clEmail`,`jjlourens2`.`setup_postal_codes`.`town` AS `town`,`jjlourens2`.`clientdetails`.`clNotes` AS `clNotes`,`jjlourens2`.`job`.`jbClaimNo` AS `jbClaimNo`,`jjlourens2`.`job`.`fk_insurer` AS `fk_insurer`,`jjlourens2`.`setup_insurer`.`pk_insurer` AS `pk_insurer`,`jjlourens2`.`setup_insurer`.`insName` AS `insName`,`jjlourens2`.`job`.`excessVal` AS `excessVal`,`jjlourens2`.`job_schedule`.`cancelReason` AS `cancelReason`,`jjlourens2`.`job_schedule`.`jobType` AS `jobType`,`jjlourens2`.`setup_scheduletype`.`pkaction` AS `pkaction`,`jjlourens2`.`setup_scheduletype`.`ActionName` AS `ActionName`,`jjlourens2`.`job_schedule`.`jobCat` AS `jobCat`,`jjlourens2`.`job_type`.`pk_jtype` AS `pk_jtype`,`jjlourens2`.`job_type`.`tName` AS `tName`,`jjlourens2`.`job_type`.`tNameShort` AS `tNameShort`,`jjlourens2`.`job_schedule`.`excessInfo` AS `excessInfo` from (((((((`jjlourens2`.`job_schedule` join `jjlourens2`.`setup_plumber`) join `jjlourens2`.`job`) join `jjlourens2`.`clientdetails`) join `jjlourens2`.`setup_postal_codes`) join `jjlourens2`.`setup_insurer` on((`jjlourens2`.`setup_insurer`.`pk_insurer` = `jjlourens2`.`job`.`fk_insurer`))) join `jjlourens2`.`setup_scheduletype` on((`jjlourens2`.`setup_scheduletype`.`pkaction` = `jjlourens2`.`job_schedule`.`jobType`))) join `jjlourens2`.`job_type` on((`jjlourens2`.`job_type`.`pk_jtype` = `jjlourens2`.`job_schedule`.`jobCat`))) where ((`jjlourens2`.`setup_postal_codes`.`pk_postal` = `jjlourens2`.`clientdetails`.`fk_postal`) and (`jjlourens2`.`clientdetails`.`pk_client` = `jjlourens2`.`job`.`fk_client`) and (`jjlourens2`.`setup_plumber`.`pk_plumber` = `jjlourens2`.`job_schedule`.`fk_plumber`) and (`jjlourens2`.`job_schedule`.`fk_job` = `jjlourens2`.`job`.`pk_job`))
md5=e2c79ebc6a27008b37946ee5e5743cd8
updatable=1
algorithm=0
definer_user=root
definer_host=localhost
suid=1
with_check_option=0
revision=2
timestamp=2013-06-07 00:12:11
create-version=1
source=SELECT
\nsetup_plumber.pname AS pname,
\nsetup_plumber.pk_plumber AS pk_plumber,
\njob.pk_job AS pk_job,
\njob.fk_client AS fk_client,
\njob_schedule.pk_schedule AS pk_schedule,
\njob_schedule.sheduleDate AS sheduleDate,
\njob_schedule.timeStart AS timeStart,
\njob_schedule.timeFinish AS timeFinish,
\njob_schedule.cancelled AS cancelled,
\njob_schedule.jobdescription AS jobdescription,
\nclientDetails.pk_client AS pk_client,
\nclientDetails.clSurname AS clSurname,
\nclientDetails.clName AS clName,
\nclientDetails.clTel1 AS clTel1,
\nclientDetails.clTel2 AS clTel2,
\nclientDetails.clPostal AS clPostal,
\nclientDetails.fk_postal AS fk_postal,
\nsetup_postal_codes.pk_postal AS pk_postal,
\nsetup_postal_codes.suburb AS suburb,
\nsetup_postal_codes.postalcd AS postalcd,
\nclientDetails.clTel3 AS clTel3,
\nclientDetails.clEmail AS clEmail,
\nsetup_postal_codes.town AS town,
\nclientDetails.clNotes AS clNotes,
\njob.jbClaimNo AS jbClaimNo,
\njob.fk_insurer AS fk_insurer,
\nsetup_insurer.pk_insurer AS pk_insurer,
\nsetup_insurer.insName AS insName,
\njob.excessVal AS excessVal,
\njob_schedule.cancelReason AS cancelReason,
\njob_schedule.jobType AS jobType,
\nsetup_scheduleType.pkaction AS pkaction,
\nsetup_scheduleType.ActionName AS ActionName,
\njob_schedule.jobCat AS jobCat,
\njob_type.pk_jtype AS pk_jtype,
\njob_type.tName AS tName,
\njob_type.tNameShort AS tNameShort,
\njob_schedule.excessInfo
\nfrom (((((((`job_schedule` join `setup_plumber`) join `job`) join `clientdetails`) join `setup_postal_codes`) join `setup_insurer` on((`setup_insurer`.`pk_insurer` = `job`.`fk_insurer`))) join `setup_scheduletype` on((`setup_scheduletype`.`pkaction` = `job_schedule`.`jobType`))) join `job_type` on((`job_type`.`pk_jtype` = `job_schedule`.`jobCat`)))
\nwhere ((`setup_postal_codes`.`pk_postal` = `clientdetails`.`fk_postal`) and (`clientdetails`.`pk_client` = `job`.`fk_client`) and (`setup_plumber`.`pk_plumber` = `job_schedule`.`fk_plumber`) and (`job_schedule`.`fk_job` = `job`.`pk_job`))