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

4 votes237 views1 answer
Sql delete multiple conditions
SQL
1 vote189 views1 answer
ELECT list is not in GROUP BY clause and contains nonaggregated column 'schogdsw_db.SE.name' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
SQL
10 votes195 views4 answers
Sql pagination
SQL
9 votes209 views5 answers
Laravel to sql
SQL
0 vote211 views1 answer
Count in sql and diff
SQL
0 vote195 views1 answer
Sql delete dastabase
SQL
8 votes200 views1 answer
Oracle search code in packages
SQL
1 vote193 views1 answer
Pl sql insert into table
SQL
2 votes226 views1 answer
Oracle Column Names of a table
SQL
0 vote201 views1 answer
Column ' ' in field list is ambiguous
SQL