We help IT Professionals succeed at work.

getting error while running below query  in sql

Satish B
Satish B asked
on
53 Views
Last Modified: 2017-04-18
The multi-part identifier "a.DROI" could not be bound.
I am trying to update the Final_OD_Status table using RBL_Overdue_Daily

update Final_OD_Status
set
a.DROI = b.debit_rate_of_interest,
a.SL = b.sanctioned_limit,
a.PO = b.principal_outstanding,
a.emiam = b.emiamt,
a.PRIDUE = b.principle_due,
a.INTDUE = b.interest_due,
a.ODUES = b.other_dues,
a.PINDue = b.penal_due,
a.TOTDue = b.total_due,
a.DPD1 = b.dpd
from Final_OD_Status as a , RBL_Overdue_Daily as b
where a.account_no = b.account_no
and Loan_status = 'Not_paid'
Comment
Watch Question

Developer
CERTIFIED EXPERT
Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION
Satish BSr. MIS executive Database Management

Author

Commented:
Thanks Nitin for your ans its working fine
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.