-
Update using 2 tables
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
Behind The Success And Failure Of A Man Is A Woman
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|