我的SQL查询有什么问题？ [英] What is wrong in the SQL query of mine?

问题描述

我的查询中有什么问题？



我的查询如下：

What is worng in the query of mine?

My query as follows:

select first.MaskedOldCardNo,first.OldCardNo,first.OldAccountNo,first.ODUtilizedAmount,first.ODLimit,first.ODBalance
from                   
(SELECT top 1 [dbo].[fnMaskCardNo](E.CardNo)as MaskedOldCardNo,E.CardNo as OldCardNo,      
E.AccountNo as OldAccountNo,select ODUtilizedAmount from (select top 1 SASR.OdUtilizationAmount as ODUtilizedAmount from SalaryAdvanceSnapShotSpecificationReport
SASR inner join  Employee E on SASR.CardNo=E.CardNo
 where CorporateId=@CorporateId and EmpId=@EmpId AND IsDeleted=1
 order by SASR.CreatedDate desc),SA.SA_Limit as ODLimit,dbo.fnGetODBalance(E.EmpId,E.CorporateId,E.CardNo) as ODBalance  FROM EMPLOYEE E inner join                 
SalaryAdvanceMaster SA on                  
SA.C3EmpRegId=E.C3EmpRegId   
inner join  dbo.SalaryAdvanceSnapShotSpecificationReport  SASR  
ON SASR.CardNo=E.CardNo           
WHERE E.EmpId=@EmpId and E.CorporateId=@CorporateId and E.SalaryAdvance=1 and E.IsDeleted=1  ORDER by E.DeletedDate desc)first

推荐答案

来自http://msdn.microsoft.com/en-us/library/c5x9a05a%28v=vs.80%29 .aspx ：

From http://msdn.microsoft.com/en-us/library/c5x9a05a%28v=vs.80%29.aspx:

Quote：

在FROM子句中，每个子查询都需要一个别名。

In the FROM clause, each subquery requires an alias.

所以每个右括号需要跟着 AS ...



我不是SQL专家（我甚至不知道你可以有一个subquer y在FROM子句中直到几分钟前），所以可能会有更多我没有发现的问题。

So each closing parenthesis needs to be followed by AS ...

I'm no SQL expert (I didn't even know you could have a subquery in the FROM clause until a few minutes ago), so there may be more problems that I haven't spotted.

这篇关于我的SQL查询有什么问题？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！