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 vote281 views1 answer
Wincc 7.4 to sql stackoverflow
SQL
3 votes270 views1 answer
Select without null values sql
SQL
5 votes242 views1 answer
Mongodb vs
SQL
0 vote255 views1 answer
Sql examples from your work
SQL
2 votes249 views2 answers
Select multiple tables mysql
SQL
1 vote272 views1 answer
Oracle duration between timestamps
SQL
0 vote227 views1 answer
Connection error in mysql workbench
SQL
-1 vote290 views1 answer
Minus vs except in sql
SQL
0 vote221 views1 answer
Sqlalchemy filter relationship
SQL
0 vote305 views1 answer
Mysql Puede ser solamente un campo automatico y este debe ser definido como una clave
SQL