1. Mysql Multiple Table Join Query
$query = "SELECT tbl_product.*, tbl_category.catName, tbl_brand.brandName FROM tbl_product
					INNER JOIN tbl_category
					ON tbl_product.catId = tbl_category.catId
					INNER JOIN tbl_brand
					ON tbl_product.brandId = tbl_brand.brandId
					ORDER BY tbl_product.productId DESC";