Incorrect Syntax near the keyword select , Incorrect Syntax near the keyword from,RSS

• • Reply
  jsshivalik

  Member

  130 Points

  476 Posts

  Incorrect Syntax near the keyword select , Incorrect Syntax near the keyword from,

  Dec 19, 2019 08:26 AM|jsshivalik|LINK

  Hi

    Below is the query

  
  SELECT T0.CardCode as CardCode,T0.CardName as CardName,(Select (Isnull(Sum(Credit),0)) from Jdt1 where ShortName = T0.CardCode - Select(isnull(Sum(T10.Credit),0) from [dbo].[JDT1] T10 inner Join Orct T11 on T10.TransId = T11.TransId and T11.Canceled = 'N' and T10.ShortName = T0.CardCode) as Balance
  FROM Ocrd T0 where T0.CardCode = 'C01'

  Thanks

• • Reply
  mgebhard

  All-Star

  47331 Points

  20738 Posts

  Re: Incorrect Syntax near the keyword select , Incorrect Syntax near the keyword from,

  Dec 19, 2019 11:26 AM|mgebhard|LINK

  The code is incomplete.   

  When asking SQL questions always share the table schema, data, and complete query.  Explain or share the expected results.    Lastly format your code before posting.

• • Reply
  PatriceSc

  All-Star

  47030 Points

  17320 Posts

  Re: Incorrect Syntax near the keyword select , Incorrect Syntax near the keyword from,

  Dec 19, 2019 11:53 AM|PatriceSc|LINK

  Hi,

  More likely a non balanced closing ). Count them or edit your statement on multiple lines to better see the structure and find the culprit.

  Make it work first but it seems it could be rewritten with joins and groups. I tend to avoid subqueries in the SELECT clause when possible as it is IMO often less clear.

• • Reply
  imapsp

  Participant

  870 Points

  223 Posts

  Re: Incorrect Syntax near the keyword select , Incorrect Syntax near the keyword from,

  Dec 19, 2019 01:04 PM|imapsp|LINK

  Hi,

  I didn't understand your query, I don't know if you will get the expected result, but try this:

  SELECT 
      T0.CardCode as CardCode,
      T0.CardName as CardName,
      (Select Isnull(Sum(Credit), 0)
       from Jdt1 
       where ShortName = T0.CardCode) - 
  
      (Select isnull(Sum(T10.Credit), 0)
       from [dbo].[JDT1] T10 
       inner Join Orct T11 on T10.TransId = T11.TransId 
       where T11.Canceled = 'N' and T10.ShortName = T0.CardCode) as Balance
  
  FROM Ocrd T0 
  where T0.CardCode = 'C01'

  Hope this help

  https://www.imoveisemexposicao.com.br/imoveis-venda-guarulhos-residencial-casa
• • Reply
  samwu

  Contributor

  2840 Points

  1194 Posts

  Re: Incorrect Syntax near the keyword select , Incorrect Syntax near the keyword from,

  Dec 26, 2019 03:30 AM|samwu|LINK

  Hi jsshivalik,

  jsshivalik

  SELECT T0.CardCode as CardCode,T0.CardName as CardName,(Select (Isnull(Sum(Credit),0)) from Jdt1 where ShortName = T0.CardCode - Select(isnull(Sum(T10.Credit),0) from [dbo].[JDT1] T10 inner Join Orct T11 on T10.TransId = T11.TransId and T11.Canceled = 'N' and T10.ShortName = T0.CardCode) as Balance
  FROM Ocrd T0 where T0.CardCode = 'C01'

  If you try the imapsp's code, then there is no Incorrect Syntax in compilation. 

  But If you still have questions, please post more information about your requirement. 

  Best regards,

  Sam

  MSDN Community Support
  Please remember to click "Mark as Answer" the responses that resolved your issue.
  If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.