TYPE=VIEW
query=select `jjlourens2`.`job_quote`.`pk_quote` AS `pk_quote`,`jjlourens2`.`job_quote`.`fk_job` AS `fk_job`,`jjlourens2`.`job_quoteitem`.`pk_quoteItem` AS `pk_quoteItem`,`jjlourens2`.`job_quoteitem`.`fk_quote` AS `fk_quote`,`jjlourens2`.`job_quoteitem`.`price` AS `price`,`jjlourens2`.`job_quote`.`addDate` AS `addDate`,`jjlourens2`.`job_quoteitem`.`quantity` AS `quantity`,`jjlourens2`.`job_quoteitem`.`qdescription` AS `qdescription`,`jjlourens2`.`job_quote`.`Description1` AS `Description1`,`jjlourens2`.`job`.`jbClaimNo` AS `jbClaimNo`,`jjlourens2`.`clientdetails`.`clSurname` AS `clSurname`,`jjlourens2`.`clientdetails`.`clName` AS `clName` from (((`jjlourens2`.`job_quote` join `jjlourens2`.`job_quoteitem` on((`jjlourens2`.`job_quote`.`pk_quote` = `jjlourens2`.`job_quoteitem`.`fk_quote`))) join `jjlourens2`.`job` on((`jjlourens2`.`job`.`pk_job` = `jjlourens2`.`job_quote`.`fk_job`))) join `jjlourens2`.`clientdetails` on((`jjlourens2`.`clientdetails`.`pk_client` = `jjlourens2`.`job`.`fk_client`))) group by `jjlourens2`.`job_quote`.`pk_quote`,`jjlourens2`.`job_quote`.`fk_job`,`jjlourens2`.`job_quote`.`Description1`,`jjlourens2`.`job_quoteitem`.`pk_quoteItem`,`jjlourens2`.`job_quoteitem`.`fk_quote`,`jjlourens2`.`job_quoteitem`.`qdescription`,`jjlourens2`.`job_quoteitem`.`delete`,`jjlourens2`.`job_quote`.`addDate`,`jjlourens2`.`job_quoteitem`.`price`
md5=3486c30024a811900495b1bd8995a79b
updatable=0
algorithm=0
definer_user=root
definer_host=localhost
suid=1
with_check_option=0
revision=2
timestamp=2013-09-18 14:19:24
create-version=1
source=SELECT
\njob_quote.pk_quote AS pk_quote,
\njob_quote.fk_job AS fk_job,
\njob_quoteItem.pk_quoteItem AS pk_quoteItem,
\njob_quoteItem.fk_quote AS fk_quote,
\njob_quoteItem.price AS price,
\njob_quote.addDate AS addDate,
\njob_quoteItem.quantity AS quantity,
\njob_quoteItem.qdescription AS qdescription,
\njob_quote.Description1 AS Description1,
\njob.jbClaimNo,
\nclientDetails.clSurname,
\nclientDetails.clName
\nFROM
\n(job_quote
\nJOIN job_quoteItem ON ((job_quote.pk_quote = job_quoteItem.fk_quote)))
\nINNER JOIN job ON job.pk_job = job_quote.fk_job
\nINNER JOIN clientDetails ON clientDetails.pk_client = job.fk_client
\ngroup by `job_quote`.`pk_quote`,`job_quote`.`fk_job`,`job_quote`.`Description1`,`job_quoteitem`.`pk_quoteItem`,`job_quoteitem`.`fk_quote`,`job_quoteitem`.`qdescription`,`job_quoteitem`.`delete`,`job_quote`.`addDate`,`job_quoteitem`.`price`