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 vote138 views1 answer
Sql server information_schema temp tables
SQL
-1 vote141 views5 answers
Operator in sql
SQL
1 vote113 views1 answer
Update from table tsql
SQL
13 votes118 views1 answer
Views in sql
SQL
4 votes124 views1 answer
Refresh postgres config
SQL
0 vote114 views1 answer
Import all databases mysql
SQL
0 vote113 views1 answer
Mysql uuid
SQL
0 vote109 views1 answer
Install mysql for fedora 34
SQL
2 votes118 views1 answer
How to select first row of database sql
SQL
7 votes117 views6 answers
Code: 'er_not_supported_auth_mode', errno: 1251, sqlmessage: 'client does not support authentication protocol requested by server; consider upgrading mysql client', sqlstate: '08004', fatal: true
SQL