catatan query postgres

select  gospay.p_authorization.p_authorization_id, gospay.gp_personal.personal_name, gospay.gp_salary.value, gospay.p_authorization.old_transaction, gospay.p_authorization.new_transaction
from gospay.gp_personal
inner join gospay.gp_salary
on gospay.gp_personal.gp_personal_id = gospay.gp_salary.gp_personal_id
inner join gospay.p_authorization
on gospay.gp_salary.gp_personal_id = gospay.p_authorization.gp_personal_id
where gospay.gp_personal.gp_personal_id =1
order by gospay.p_authorization.p_authorization_id desc
limit 1

==================================

Tweet