MySQL Forums
Forum List  »  Spanish

Necesito ayuda para una consulta MYSQL
Posted by: jesus alberto
Date: July 05, 2016 04:45AM

select avg(notas2016.definitiva) as promedio from notas2016, asignatura2016
where

notas2016.ID_ESTUDIANTE='1005574330' and
notas2016.vigencia='2016' and notas2016.grado='8' and notas2016.grupo='A' and
notas2016.periodo='I' and notas2016.TIPO_JORNADA='2' and notas2016.sede ='170001001861'

and notas2016.asignatura=asignatura2016.codigo and asignatura2016.juicio<>'X'
group by asignatura2016.area

Options: ReplyQuote


Subject
Views
Written By
Posted
Necesito ayuda para una consulta MYSQL
1211
July 05, 2016 04:45AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.