Tech
Forums
Jobs
Books
Events
Interviews
Live
More
Learn
Training
Career
Members
Videos
News
Blogs
Login
Sign Up
Ask Question
3
Reply
Geting Error in Delete Query
Ajith kp
Feb 11 2014 3:16 AM
1k
Reply
DELETE FROM Loan_GL_LoanDetails Where loan_id IN(SELECT TOP 1 * FROM Loan_GL_LoanDetails LD
Inner Join Loan_GL_LoanMaster LM on LM.loan_id=LD.loan_id
where LM.loan_no = @loan_no ORDER BY LD.ld_id DESC)
Error :
Only one expression can be specified in the select list when the subquery is not introduced with EXISTS.
Upload Source Code
Select only zip and rar file.
Post
Reset
Cancel
Answers (
3
)
Next Recommended Forum
registration form using stored procedure in asp.net
hours calculation in sql