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

1 vote325 views1 answer
Show table status command in mysql
SQL
0 vote316 views1 answer
Mod function example
SQL
2 votes316 views1 answer
Postgresql add entry to table
SQL
0 vote411 views1 answer
Jpa generationtype sequence mysql
SQL
2 votes336 views1 answer
SELECT INTO
SQL
1 vote338 views1 answer
Cannot drop database because it is currently in use
SQL
61 votes535 views6 answers
Mysql add column
SQL
1 vote278 views1 answer
Into sql
SQL
0 vote330 views3 answers
Joins and views sql
SQL
5 votes391 views1 answer
Oracle drop index if exists
SQL