consulta SQL:
SELECT a.nombres AS nombreAlumno, m.materia AS nombreMateria, IFNULL( k.calif1A, 'NO CALIFICADO' ) AS calif1A
FROM materias m
LEFT OUTER
JOIN kardex k ON m
.codigomateria
= k
.codigomateria
LEFT OUTER
JOIN alumnos a ON k
.matricula
= a
.matricula
WHERE k.matricula = '91901014430'
OR k.matricula IS NULL
LIMIT 0 , 30
#1267 - #1267 - Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (latin1_spanish_ci,IMPLICIT) for operation '='
Hola Alguien me podria ayudar a descifrar este error.
me marca enmedio de estos 2
LEFT OUTER JOIN kardex k ON m.codigomateria = k.codigomateria
LEFT OUTER JOIN alumnos a ON k.matricula = a.matricula
saludos