"SELECT MIN(nbofphase) as minimo FROM
(SELECT class_id,COUNT(ph_id) as nbofphase
FROM tbl_phases right join tbl_projects on (tbl_phases.project_id = tbl_projects.project_id)
WHERE (class_id=:classID)
group by class_id,tbl_phases.project_id)
"
,array(':classID'=>$class_id)
);
e ho un errore :
Syntax error or access violation: 1248 Every derived table must have its own alias
SELECT MIN(nbofphase) as minimo FROM
(
SELECT class_id,COUNT(ph_id) as nbofphase
FROM tbl_phases right join tbl_projects on (tbl_phases.project_id = tbl_projects.project_id)
WHERE (class_id=:classID)
group by class_id,tbl_phases.project_id
) derivedTable1