Tag Archives: sum of multiple columns in mysql

Count of multiple fields in a join query in mysql

This is the query i used to fetch count of multiple fields from my table.I used four times select query inside a query before doing join

you can see the database structure and query result as below