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