Update using 2 tables

[yxez]

I tried it but it hanged up.... :(

update loans l set l.status='PAID WITHIN REQUIRED TERMS'
where l.payment_term>=
(select max(p.payment_date)
from payment p
where l.empid = p.empid
and l.loan_type = p.loan_type
- l.loan_date )
;