21st Jun 2018help me please. how to "SELECT DISTINCT" in dataeditor?
' Editor::inst( $db, 'tb_table' )
' ->field(
' Field::inst('tb_table.id_group'),
' Field::inst('tb_table.subjcode'),
' Field::inst('tb_table.subjgroup'),
' Field::inst('tb_table.term'),
' Field::inst('tb_table.stu_type'),
' Field::inst('tb_subjgroup.group_tname'),
' Field::inst('tb_faculty.fac_tname'),
' Field::inst('tb_course.subjname1'),
' Field::inst('tb_stu_type.id_type'),
' Field::inst('tb_stu_type.type_name'),
' Field::inst('tb_course.crhr'),
' Field::inst('tb_program.prg_tname'),
' Field::inst('tb_table.tea_sname'),
' Field::inst('tb_table.tea_sname2'),
' Field::inst('tb_table.tea_sname3'),
' Field::inst('tb_table.time'),
' Field::inst('tb_table.time2'),
' Field::inst('tb_table.time3'),
' Field::inst('tb_table.room'),
' Field::inst('tb_table.room2'),
' Field::inst('tb_table.room3'),
' Field::inst('tb_table.homeroom')
' )
'
' ->leftJoin('tb_subjgroup','tb_table.subjgroup','=','tb_subjgroup.id_subjgroup')
' ->leftJoin('tb_stu_group','tb_table.id_group','=','tb_stu_group.id_group')
' ->leftJoin('tb_program','tb_stu_group.id_program ','=','tb_program.id_program')
' ->leftJoin('tb_faculty','tb_program.id_faculty','=','tb_faculty.id_faculty')
' ->leftJoin('tb_course','tb_table.subjcode','=','tb_course.subjcode')
' ->leftJoin('tb_stu_type','tb_stu_group.id_type','=','tb_stu_type.id_type')
' ->where( 'tb_table.term', $_POST['term'])
' ->where( 'tb_faculty.id_faculty', $_POST['facultyId'])