Member Avatar for rjusman90 
here is the normal rows coming 

![WhatsApp_Image_2019-11-04_at_2_32_36_PM.jpeg](/attachments/large/4/f5be1a527695a5bf62797e287c220820.jpeg)

i want to show the group by product name with the count of store as the below picture

![WhatsApp_Image_2019-11-04_at_3_28_58_PM.jpeg](/attachments/large/4/b96ff7cb890fb01e6de9e5540a7e7a9e.jpeg)

here are mysql query 

SELECT
i.barcode,
i.name,
u.company_name,
COUNT(i.id) AS IQTY,
COUNT(U.id) AS UQTY
FROM
inventory i,
USER u
  • 2 Contributors
  • 1 Reply
  • 254 Views
  • 7 Hours Discussion Span
  • Latest Post Latest Post by Reverend Jim
Member Avatar for Reverend Jim

I suggest you post your schema and data here. Whatever you posted above isn't of any help. Keep in mind that if anyone wants to run a test against your schema/data it is much easier to set up the test when we can copy/paste data - something we can't do from a jpg screencap.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.