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 vote144 views1 answer
Sql delete dastabase
SQL
1 vote135 views1 answer
Set autoincrement to 0
SQL
11 votes123 views2 answers
Having clause
SQL
0 vote139 views1 answer
Every Derived yable must have its own alias
SQL
0 vote160 views8 answers
Sql to c# linq converter online
SQL
1 vote127 views1 answer
Sql get all columns from one table but one from another inner join
SQL
0 vote160 views2 answers
Getting customers with no orders sql
SQL
12 votes132 views2 answers
Delete entries in postgresql
SQL
0 vote125 views1 answer
Set a default value for a column in sqlite
SQL
0 vote137 views1 answer
Rename view mysql
SQL