Ajith kp

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.
 

Answers (3)