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 = '3301214001'