Satish B
asked on
Incorrect syntax near the keyword 'INNER'
UPDATE a
SET a.Loan_status = 'Not paid'
FROM RBL_Overdue_Main a where a.T_Month ='May-17'
INNER JOIN RBL_Overdue_Daily b ON b.account_no = a.account_no;
here i want to add where a.T_Month ='May-17' condition but its giving me error
SET a.Loan_status = 'Not paid'
FROM RBL_Overdue_Main a where a.T_Month ='May-17'
INNER JOIN RBL_Overdue_Daily b ON b.account_no = a.account_no;
here i want to add where a.T_Month ='May-17' condition but its giving me error
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
If the answer is working, you are supposed to accept the comment to close the question
ASKER