Mysql two joins

SELECT areas.name AS aname, COUNT(consultants.active) AS cct 
    FROM areas 
    LEFT JOIN consAreas 
      ON consAreas.area = areas.id 
    LEFT JOIN consultants 
      ON consultants.id = consAreas.cons
   WHERE areas.areaID = $area 
     AND consultants.active = 1
GROUP BY areas.name
ORDER BY areas.name

Source: stackoverflow.com

Similar codes

0 vote244 views1 answer
FIND LOWEST SALARY EARNER IN SQL
SQL
1 vote196 views1 answer
SQLite order random
SQL
1 vote185 views1 answer
Sql Split string function
SQL
0 vote265 views1 answer
Get initials name in sql
SQL
0 vote203 views1 answer
Mysql database hyphen
SQL
0 vote200 views1 answer
Database schema for mcqs type exam in sql
SQL
1 vote204 views4 answers
Psql: error: FATAL: database "odoo" does not exist
SQL
8 votes202 views1 answer
Oracle all_source package body
SQL
0 vote214 views1 answer
Sql put two columns into one
SQL
0 vote227 views1 answer
Sql value exists in column
SQL