troubleshooting Question

getting error while running below query in sql

Avatar of Satish B
Satish B asked on
Microsoft SQL Server
2 Comments1 Solution61 ViewsLast Modified:
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'
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 2 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 2 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros