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`,`jjlourens2`.`job_quote`.`quoteType` AS `quoteType`,`jjlourens2`.`job_quote`.`AddNote` AS `AddNote` from (`jjlourens2`.`job_quote` join `jjlourens2`.`job` on((`jjlourens2`.`job`.`pk_job` = `jjlourens2`.`job_quote`.`fk_job`)))
md5=eaea58c546269d1c4a905e41364c2420
updatable=1
algorithm=0
definer_user=root
definer_host=localhost
suid=1
with_check_option=0
revision=2
timestamp=2013-11-07 00:19:23
create-version=1
source=SELECT
\njob_quote.pk_quote AS pk_quote,
\njob_quote.addDate AS addDate,
\njob_quote.Description1 AS Description1,
\njob_quote.fk_job AS fk_job,
\njob_quote.userAdd AS userAdd,
\njob_quote.rndm1 AS rndm1,
\njob_quote.qstatus AS qstatus,
\njob_quote.qreason AS qreason,
\njob_quote.qNote AS qNote,
\njob.jbClaimNo AS jbClaimNo,
\njob_quote.quoteType,
\njob_quote.AddNote
\nfrom (`job_quote` join `job` on((`job`.`pk_job` = `job_quote`.`fk_job`)))