SELECT shop_registration.shop_id, shop_name, shop_category
INNER JOIN system ON system.shop_id = shop_registration.shop_id
INNER JOIN bill ON bill.sys_id = system.sys_id
WHERE `yb_id` = '$yb_id' GROUP BY shop_id
I want the data from bill, system and shop_registration wherein I will get bill count, bill, date from bill and shop_id,shop_name,shop_category.
So far from the above query I'm getting shop_name, shop-id and shop-category based on yb_id