SELECT
    A.*,
    FULLNAME,
    BANKACCOUNT,
    NAMEOFGRADE,
    NPWP,
    SALARY,
    TRANSPORTCOST * GET_SALARYTRANSPORT(PERIODE,
    SCHOOLYEAR) TRANSPORT
FROM
    LECTURERSALARYRECAP A
LEFT JOIN LECTURERSALARY B ON
    (A.LECTURERCODE = B.LECTURERCODE)
WHERE
    PERIODE = '05'
    AND SCHOOLYEAR = '2324'
    AND SEMESTER = '2'
    AND STUDYPROGRAMID = '44'
    AND GENERATESALARYID = 17870