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