AppGini Community Forums

Code: Select all

SELECT `subject`.`subject_code`, IF(CHAR_LENGTH(`subject`.`subject_code`) || CHAR_LENGTH(`subject`.`subject_name`),
 CONCAT_WS('', `subject`.`subject_code`, '  ', `subject`.`subject_name`), '') FROM `subject` LEFT JOIN `subject` as subject1 ON `subject1`.`subject_code`=`subject`.`pre_requested`

WHERE `subject`.`pre_requested` is Null OR
`subject`.`pre_requested` IN (SELECT `subject`.`subject_code` from `subject`,`stud_result`,`student` WHERE 
`subject`.`subject_code`=`stud_result`.`subject_code` and `stud_result`.`stud_code`= 'stu1001' AND `stud_result`.`status`='win') ORDER BY 2