I have two tables: CATEGORY
and SUBCATEGORY
Table Structure for CATEGORY
category_id int(11)
category_name varchar(250)
category_status enum('0', '1')
Table Structure for SUBCATEGORY
subcategory_id int(10)
subcategory_name varchar(255)
status enum('0', '1')
For example there is a single CATEGORY
named .NET and it has entries in SUBCATEGORY
like ASP.NET, VB.NET, C#.NET . In this case I need to get the count of CATEGORY
as 1 and the count of SUBCATEGORY
as 3 using MySQL.
How can I accomplish this?