hello sir multiple tables how to fetch data in single query : SELECT
     tbl_category.`cat_name` AS tbl_category_cat_name,
     registration.`firm_name` AS registration_firm_name,
     tbl_prod.`prod_name` AS tbl_prod_prod_name,
     tbl_prod.`prod_desc` AS tbl_prod_prod_desc,
     tbl_prod.`prod_size` AS tbl_prod_prod_size,
     tbl_prod.`prod_prate` AS tbl_prod_prod_prate,
     tbl_prod.`prod_mrp` AS tbl_prod_prod_mrp,
     tbl_prod.`prod_srate` AS tbl_prod_prod_srate,
     tbl_unit.`unit` AS tbl_unit_unit,
     tbl_brand.`bnd_name` AS tbl_brand_bnd_name
FROM
     `tbl_category` tbl_category,
     `registration` registration,
     `tbl_prod` tbl_prod,
     `tbl_unit` tbl_unit,
     `tbl_brand` tbl_brand