Update using 2 tables

[yxez]

Hi Pavb,

Another one pls...

LAONS
=====
EMPID NUMBER(5),
LOAN_TYPE VARCHAR2(20),
LOAN_DATE DATE,
LOAN_AMOUNT NUMBER(7,2),
PAYMENT_TERM NUMBER, #in days
STATUS VARCHAR2(10)

PAYMENTS
========
EMPID NUMBER(5),
LOAN_TYPE VARCHAR2(20),
PAYMENT_DATE DATE,
PAYMENT_AMOUNT NUMBER(5,2)


LOANS
=====

EMPID LOAN_TYPE LOAN_DATE LOAN_AMOUNT Payment_term STATUS
===== ========= ========= =========== ============ ======
111 SALARY 01-JAN-06 1200 365


PAYMENTS
========

EMPID LOAN_TYPE PAYMENT_DATE PAYMENT_AMOUNT
===== ========= ============ ==============
111 SALARY 01-FEB-07 100
111 SALARY 01-MAR-07 100
111 SALARY 01-APR-07 100
111 SALARY 01-MAY-07 100
111 SALARY 01-JUN-07 100
111 SALARY 01-JUL-07 100
111 SALARY 01-AUG-07 100
111 SALARY 01-SEP-07 100
111 SALARY 01-OCT-07 100
111 SALARY 01-NOV-07 100
111 SALARY 01-DEC-07 100
111 SALARY 01-JAN-07 100



I want to update the LOANS.STATUS = 'PAID WITHIN REQUIRED TERMS'
IF (LAST PAYMENT_DATE - LOAN_DATE) <= PAYMENT_TERM
WHERE LOANS.EMPID=PAYMENTS.EMPID
AND LOANS.LOAN_TYPE=PAYMENTS.LOAN_TYPE


can you help me the syntax pls....thanks