TYPE=VIEW query=select `jjlourens2`.`productcategory`.`categoryName` AS `categoryName`,`jjlourens2`.`productunittype`.`unitName` AS `unitName`,`jjlourens2`.`productsub`.`description` AS `description`,`jjlourens2`.`productsub`.`salesPrice` AS `salesPrice`,`jjlourens2`.`productmain`.`productName` AS `productName`,`jjlourens2`.`setup_insurer`.`pk_insurer` AS `pk_insurer`,`jjlourens2`.`setup_insurer`.`insName` AS `insName`,`jjlourens2`.`productsubcategory`.`subCatDescription` AS `subCatDescription` from (((((`jjlourens2`.`productmain` join `jjlourens2`.`productcategory` on((`jjlourens2`.`productcategory`.`pkProductCategory` = `jjlourens2`.`productmain`.`fkProductSubCategory`))) join `jjlourens2`.`productsub` on((`jjlourens2`.`productmain`.`pkProductMain` = `jjlourens2`.`productsub`.`fkProductMain`))) join `jjlourens2`.`productsubcategory` on((`jjlourens2`.`productcategory`.`pkProductCategory` = `jjlourens2`.`productsubcategory`.`fkProductCategory`))) join `jjlourens2`.`productunittype` on((`jjlourens2`.`productunittype`.`pkProductUnitType` = `jjlourens2`.`productsub`.`fkProductUnitType`))) join `jjlourens2`.`setup_insurer` on((`jjlourens2`.`setup_insurer`.`pk_insurer` = `jjlourens2`.`productsub`.`fkInsurer`))) md5=1d20aa51f3527f419a86673047a75524 updatable=1 algorithm=0 definer_user=root definer_host=localhost suid=1 with_check_option=0 revision=2 timestamp=2013-04-24 14:10:21 create-version=1 source=SELECT \nproductCategory.categoryName, \nproductUnitType.unitName, \nproductSub.description, \nproductSub.salesPrice, \nproductMain.productName, \nsetup_insurer.pk_insurer, \nsetup_insurer.insName, \nproductSubCategory.subCatDescription \nFROM \nproductMain \nINNER JOIN productCategory ON productCategory.pkProductCategory = productMain.fkProductSubCategory \nINNER JOIN productSub ON productMain.pkProductMain = productSub.fkProductMain \nINNER JOIN productSubCategory ON productCategory.pkProductCategory = productSubCategory.fkProductCategory \nINNER JOIN productUnitType ON productUnitType.pkProductUnitType = productSub.fkProductUnitType \nINNER JOIN setup_insurer ON setup_insurer.pk_insurer = productSub.fkInsurer