Need to write Mysql query showing statistics,
Description:
Parent table 60 lac records contains unique records
Child table with 1 crore Contains multiple records
Parent Table
ID Flag1 Flag2
1 1 1
2 NULL 1
3 1 1
Child Table
ID acc Category
1 101 Cate1
1 102 Cate5
2 103 Cate2
2 104 Cate3
3 105 Cate4
3 106 Cate4
One to many relationship between two tables.
I need to write group by queries to find categoriwise and flag based count in one query with MySQL Database
sample:
I have tried with following query but i dont want to write where condition for each category and Flag as Child table contains 30 categories and 12 Flags
select count(1) from Parent A,Child B where A.ID=B.ID AND B.Category='CATE1' and A.Flag1=1
Result expected
Category Flag1_Count Flag2_Count
Cate1 1 0
Cate2 0 1
Cate3 1 1
Please help.