TYPE=VIEW query=select `jjlourens2`.`job_quote`.`pk_quote` AS `pk_quote`,`jjlourens2`.`job_quote`.`addDate` AS `addDate`,`jjlourens2`.`job_quote`.`Description1` AS `Description1`,`jjlourens2`.`job_quote`.`fk_job` AS `fk_job`,`jjlourens2`.`job_quote`.`userAdd` AS `userAdd`,`jjlourens2`.`job_quote`.`rndm1` AS `rndm1`,`jjlourens2`.`job_quote`.`qstatus` AS `qstatus`,`jjlourens2`.`job_quote`.`qreason` AS `qreason`,`jjlourens2`.`job_quote`.`qNote` AS `qNote`,`jjlourens2`.`job`.`jbClaimNo` AS `jbClaimNo` from (`jjlourens2`.`job_quote` join `jjlourens2`.`job` on((`jjlourens2`.`job`.`pk_job` = `jjlourens2`.`job_quote`.`fk_job`))) md5=c3c33d5bb9c8f3b13a06c47f6c075284 updatable=1 algorithm=0 definer_user=root definer_host=localhost suid=1 with_check_option=0 revision=1 timestamp=2013-07-24 00:12:02 create-version=1 source=select `job_quote`.`pk_quote` AS `pk_quote`,`job_quote`.`addDate` AS `addDate`,`job_quote`.`Description1` AS `Description1`,`job_quote`.`fk_job` AS `fk_job`,`job_quote`.`userAdd` AS `userAdd`,`job_quote`.`rndm1` AS `rndm1`,`job_quote`.`qstatus` AS `qstatus`,`job_quote`.`qreason` AS `qreason`,`job_quote`.`qNote` AS `qNote`,`job`.`jbClaimNo` AS `jbClaimNo` from (`job_quote` join `job` on((`job`.`pk_job` = `job_quote`.`fk_job`)))