Sql query error

Ciao,

sto eseguendo una query:

$minimo=Projects::model()->findAllBySql(

                     "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

sapete come risolvere?

si’, devi dare un alias alla tabella derivata:





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



O cosi’ o con gli apici su ‘derivedTable1’.

Prova e fammi sapere se risolve

ti confermo che funziona senza l’uso degli apici

ti ringrazio