TYPE=VIEW
query=select `jjlourens2`.`job`.`pk_job` AS `pk_job`,`jjlourens2`.`clientdetails`.`pk_client` AS `pk_client`,`jjlourens2`.`clientdetails`.`clSurname` AS `clSurname`,`jjlourens2`.`clientdetails`.`clName` AS `clName`,`jjlourens2`.`job_notes`.`pk_notes` AS `pk_notes`,`jjlourens2`.`job`.`userInCharge` AS `userInCharge`,`jjlourens2`.`setup_notetype`.`pk_appType` AS `pk_appType`,`jjlourens2`.`setup_notetype`.`typeName` AS `typeName`,`jjlourens2`.`job_notes`.`followUpDate` AS `followUpDate`,`jjlourens2`.`job`.`fk_client` AS `fk_client`,`jjlourens2`.`job_notes`.`noteType` AS `noteType`,`jjlourens2`.`job_notes`.`complete` AS `complete`,`jjlourens2`.`job_notes`.`followtime` AS `followtime`,`jjlourens2`.`job_notes`.`fkUType` AS `fkUType`,`jjlourens2`.`job`.`finuInCharge` AS `finuInCharge`,`jjlourens2`.`job_notes`.`noteFor` AS `noteFor`,`jjlourens2`.`job_notes`.`tracknote` AS `tracknote` from (((`jjlourens2`.`job` join `jjlourens2`.`clientdetails` on((`jjlourens2`.`clientdetails`.`pk_client` = `jjlourens2`.`job`.`fk_client`))) join `jjlourens2`.`job_notes` on((`jjlourens2`.`job`.`pk_job` = `jjlourens2`.`job_notes`.`fk_job`))) join `jjlourens2`.`setup_notetype` on((`jjlourens2`.`setup_notetype`.`pk_appType` = `jjlourens2`.`job_notes`.`noteType`)))
md5=0ee0cf6f32082af692015dec9afc01de
updatable=1
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 `job`.`pk_job` AS `pk_job`,`clientdetails`.`pk_client` AS `pk_client`,`clientdetails`.`clSurname` AS `clSurname`,`clientdetails`.`clName` AS `clName`,`job_notes`.`pk_notes` AS `pk_notes`,`job`.`userInCharge` AS `userInCharge`,`setup_notetype`.`pk_appType` AS `pk_appType`,`setup_notetype`.`typeName` AS `typeName`,`job_notes`.`followUpDate` AS `followUpDate`,`job`.`fk_client` AS `fk_client`,`job_notes`.`noteType` AS `noteType`,`job_notes`.`complete` AS `complete`,`job_notes`.`followtime` AS `followtime`,`job_notes`.`fkUType` AS `fkUType`,`job`.`finuInCharge` AS `finuInCharge`,`job_notes`.`noteFor` AS `noteFor`,`job_notes`.`tracknote` AS `tracknote` from (((`job` join `clientdetails` on((`clientdetails`.`pk_client` = `job`.`fk_client`))) join `job_notes` on((`job`.`pk_job` = `job_notes`.`fk_job`))) join `setup_notetype` on((`setup_notetype`.`pk_appType` = `job_notes`.`noteType`)))