query help

[gmc1103]

Hello

 

I'm having a problem regarding a query because i don't have all the records and i don't know why

This is the query

SELECT `ebspma_paad_ebspma`.`semana_dias`.`dia`,`ebspma_paad_ebspma`.`req_material_sala`.`sala`, `ebspma_paad_ebspma`.`req_material_tempo`.`inicio`, `ebspma_paad_ebspma`.`sala_ocupacao`.`id_ocup`, `ebspma_paad_ebspma`.`turmas`.`turma`
        FROM `ebspma_paad_ebspma`.`sala_ocupacao` INNER JOIN `ebspma_paad_ebspma`.`semana_dias` ON (`sala_ocupacao`.`id_dia` = `semana_dias`.`id_dia`)
        INNER JOIN `ebspma_paad_ebspma`.`req_material_sala` ON (`sala_ocupacao`.`id_sala` = `req_material_sala`.`idsala`)
        LEFT  JOIN `ebspma_paad_ebspma`.`req_material_tempo` ON (`sala_ocupacao`.`id_tempo` = `req_material_tempo`.`idtempo`)
        LEFT  JOIN `ebspma_paad_ebspma`.`turmas` ON (`sala_ocupacao`.`id_turma` = `turmas`.`id_turma`)
        where`ebspma_paad_ebspma`.`sala_ocupacao`.`id_turma` = '$turma' GROUP BY  `ebspma_paad_ebspma`.`sala_ocupacao`.`id_dia` ,  `ebspma_paad_ebspma`.`req_material_tempo`.`inicio` ASC

And i have this result (school_result.jpg) and it should be (school_result_correct.jpg) because in my school timetable i have two classroom for that class (school.jpg)

 

Any help why i can't have those values?

 

Thanks

 

[Barand]

Don't know, I can't see the data from here.

[gmc1103]

Hi Barand

Thanks for your information, i fixed the issue using group by day, class, time, then order by day and time.

 

Thanks

[Barand]

Sorry I couldn't be more helpful but I wasn't going to attempt to juggle data from five tables of unknown structure and content in my head.