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

6 votes186 views2 answers
Postgresql database url
SQL
2 votes208 views2 answers
Storing timezones in postgres
SQL
0 vote220 views1 answer
Pl sql search in all packages
SQL
2 votes177 views1 answer
Oracle virtual column
SQL
0 vote179 views2 answers
Alter table add multiple columns mysql
SQL
12 votes211 views6 answers
Distinct in sql server
SQL
17 votes212 views1 answer
Selecting name that contain certain word in sql
SQL
3 votes214 views1 answer
Apex set debug level
SQL
0 vote174 views1 answer
C# mysql data reader from two tables
SQL
2 votes185 views1 answer
Oracle list grants on procedure
SQL