Paul, Try
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 group by c.id HAVING num_profe_curso > 0 Andy > -----Original Message----- > From: Paul [mailto:[EMAIL PROTECTED] > Sent: 07 July 2003 19:56 > To: [EMAIL PROTECTED] > Subject: issue with 'count' > > > 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] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
