TYPE=VIEW
query=select `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`.`clTel3` AS `clTel3`,`jjlourens2`.`clientdetails`.`clIDnum` AS `clIDnum`,`jjlourens2`.`clientdetails`.`clPostal` AS `clPostal`,`jjlourens2`.`clientdetails`.`clEmail` AS `clEmail`,`jjlourens2`.`clientdetails`.`clPostalcd` AS `clPostalcd`,`jjlourens2`.`setup_postal_codes`.`pk_postal` AS `pk_postal`,`jjlourens2`.`setup_postal_codes`.`suburb` AS `suburb`,`jjlourens2`.`setup_postal_codes`.`town` AS `town`,`jjlourens2`.`clientdetails`.`fk_postal` AS `fk_postal`,`jjlourens2`.`clientdetails`.`clDateJoin` AS `clDateJoin` from (`jjlourens2`.`clientdetails` join `jjlourens2`.`setup_postal_codes` on((`jjlourens2`.`setup_postal_codes`.`pk_postal` = `jjlourens2`.`clientdetails`.`fk_postal`)))
md5=35ca836001e7584d5d313de29455e363
updatable=1
algorithm=0
definer_user=root
definer_host=localhost
suid=1
with_check_option=0
revision=1
timestamp=2013-10-30 23:13:56
create-version=1
source=select `clientdetails`.`pk_client` AS `pk_client`,`clientdetails`.`clSurname` AS `clSurname`,`clientdetails`.`clName` AS `clName`,`clientdetails`.`clTel1` AS `clTel1`,`clientdetails`.`clTel2` AS `clTel2`,`clientdetails`.`clTel3` AS `clTel3`,`clientdetails`.`clIDnum` AS `clIDnum`,`clientdetails`.`clPostal` AS `clPostal`,`clientdetails`.`clEmail` AS `clEmail`,`clientdetails`.`clPostalcd` AS `clPostalcd`,`setup_postal_codes`.`pk_postal` AS `pk_postal`,`setup_postal_codes`.`suburb` AS `suburb`,`setup_postal_codes`.`town` AS `town`,`clientdetails`.`fk_postal` AS `fk_postal`,`clientdetails`.`clDateJoin` AS `clDateJoin` from (`clientdetails` join `setup_postal_codes` on((`setup_postal_codes`.`pk_postal` = `clientdetails`.`fk_postal`)))