Current Table name “1_alumnos”
// $maestroID=‘‘1;
// $rs = Execute(“SELECT 1_alumno_nombres, 1_maestro_id, 1_alumno_clase, 2_clase_id, 2_clase_teacher FROM 1_maestros
// INNER JOIN 2_clases ON 2_clase_teacher = 1_maestro_id
// INNER JOIN 1_alumnos ON FIND_IN_SET(2_clase_id, 1_alumno_clase)
// WHERE 2_clase_teacher = '”. $maestroID ."’
// “);
// if ($rs && $rs->RecordCount() > 0) {
// $sFilter = “”;
// while (!$rs->EOF) {
// $sFilter .= “1_alumno_clase = '”.$rs->fields(“2_clase_id”).”’ OR";
// $rs->MoveNext();
// }
// $sFilter = rtrim($sFilter, “OR”);
// AddFilter($filter, $sFilter);
// $rs->Close();
// }
\
The following query does the job, but not in recorset_selecting:
SELECT 1_maestro_nombres, 1_alumno_nombres, 2_clase_nombre FROM 1_maestros
INNER JOIN 2_clases ON 2_clase_teacher = 1_maestro_id
INNER JOIN 1_alumnos ON FIND_IN_SET(2_clase_id, 1_alumno_clase)
WHERE 2_clase_teacher= ‘1’