Hi Friends,


I have two tables LOANS AND PAYMENTS

LAONS
=====
EMPID NUMBER(5),
LOAN_TYPE VARCHAR2(20),
LOAN_DATE DATE,
LOAN_AMOUNT NUMBER(7,2),
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 STATUS
===== ========= ========= =========== ======
111 SALARY 01-JAN-06 1000


PAYMENTS
========

EMPID LOAN_TYPE PAYMENT_DATE PAYMENT_AMOUNT
===== ========= ============ ==============
111 SALARY 01-FEB-07 100
111 SALARY 01-FEB-07 100
111 SALARY 01-FEB-07 100
111 SALARY 01-FEB-07 100
111 SALARY 01-FEB-07 100
111 SALARY 01-FEB-07 100
111 SALARY 01-FEB-07 100
111 SALARY 01-FEB-07 100
111 SALARY 01-FEB-07 100
111 SALARY 01-FEB-07 100


I want to update the LOANS.STATUS = 'PAID'
IF SUM(PAYMENT_AMOUNT) >= LOAN_AMOUNT WHERE LOANS.EMPID=PAYMENTS.EMPID
AND LOANS.LOAN_TYPE=PAYMENTS.LOAN_TYPE


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