[sbondi]

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?

[zaccaria]

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

[sbondi]

zaccaria, on 03 December 2010 - 05:31 AM, said:

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