SELECT
	FT.*,
	(
	SELECT
		LECTURERCODE
	FROM
		FINALTASKADVISOR
	WHERE
		FINALTASKID = FT.FINALTASKID
		AND ADVISORSTATUS = '1' ) AS LECTURER_CODE_1,
	(
	SELECT
		LOOK_LECTURERNAME(LECTURERCODE)
	FROM
		FINALTASKADVISOR
	WHERE
		FINALTASKID = FT.FINALTASKID
		AND ADVISORSTATUS = '1' ) AS LECTURER_NAME_1,
	(
	SELECT
		LECTURERCODE
	FROM
		FINALTASKADVISOR
	WHERE
		FINALTASKID = FT.FINALTASKID
		AND ADVISORSTATUS = '2' ) AS LECTURER_CODE_2,
	(
	SELECT
		LOOK_LECTURERNAME(LECTURERCODE)
	FROM
		FINALTASKADVISOR
	WHERE
		FINALTASKID = FT.FINALTASKID
		AND ADVISORSTATUS = '2' ) AS LECTURER_NAME_2
FROM
	FINALTASK FT
WHERE
	FT.STUDENTID = '1501204238';