hi to all, and thank for your valuable help....
my problem SELECT c.id, count(cug2.id_curso) as num_profe_curso FROM nuke_elearning_curso as c, LEFT JOIN nuke_elearning_curso_usuario_grupo as cug2 ON c.id = cug2.id_curso WHERE num_profe_curso > 0 group by c.id esta sentencia sql busca la cantidad de profes para cada uno de los cursos me da error en que es desconocida la columna num_profe_curso, hay alguna manera de accesar a esa columna? this sql statement search the number of teachers to each of the courses in the 'c' table. the server mysql give me error because the column 'num_profe_curso' is unknown, is there a way to access a this column?? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
