filter by

[amyat]

hello
can u help me for simple query
https://imgur.com/fR8hjPZ
my query is

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

what i need to change from 'stu1001'...
help me please
sry for my not enough knowledge

[pbottcher]

Hi,

can you please explain more detailed what you try to do. When is the query needed? Where did you put the query?