TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
Ajith kp
1.6k
145
33.5k
Geting Error in Delete Query
Feb 11 2014 3:16 AM
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.
Reply
Answers (
3
)
registration form using stored procedure in asp.net
hours calculation in sql