sql查询给出了无效的列名 [英] sql query gives invalid column name

问题描述

在第1列添加自由文本时出现错误。我该如何解决这个问题？

When adding "Free Text" to column 1 I get an error. How can I fix this?

SELECT CAST(T1. [Free_Text]  as varchar(250)), CardCode, CardName, PymntGroup, SUM(Balance) BALANCE, SUM(A) FUTURE, SUM(B) '0-30', SUM(C) '31-60', SUM(D) '61-90', SUM(E) '91-120', SUM(F) '121+' FROM (
SELECT CAST(T1. [Free_Text]  as varchar(250)),T1.CardCode, T1.CardName, T2.[PymntGroup], T0.RefDate, T0.Ref1 'Document_Number',
     CASE  WHEN T0.TransType=13 THEN 'Invoice'
          WHEN T0.TransType=14 THEN 'Credit Note'
          WHEN T0.TransType=30 THEN 'Journal'
          WHEN T0.TransType=24 THEN 'Receipt'
          END AS 'Document_Type',
     T0.DueDate, (T0.Debit- T0.Credit) 'Balance'
     ,ISNULL((SELECT T0.Debit-T0.Credit WHERE DateDiff(day, T0.DueDate, getdate())<=-1),0) 'A'
     ,ISNULL((SELECT T0.Debit-T0.Credit WHERE DateDiff(day, T0.DueDate,getdate())>=0 and DateDiff(day, T0.DueDate,getdate())<=30),0) 'B'
     ,ISNULL((SELECT T0.Debit-T0.Credit WHERE DateDiff(day, T0.DueDate,getdate())>30 and DateDiff(day, T0.DueDate,getdate())<=60),0) 'C'
     ,ISNULL((SELECT T0.Debit-T0.Credit WHERE DateDiff(day, T0.DueDate,getdate())>60 and DateDiff(day, T0.DueDate,getdate())<=90),0) 'D'
     ,ISNULL((SELECT T0.Debit-T0.Credit WHERE DateDiff(day, T0.DueDate,getdate())>90 and DateDiff(day, T0.DueDate,getdate())<=120),0) 'E'
     ,ISNULL((SELECT T0.Debit-T0.Credit WHERE DateDiff(day, T0.DueDate,getdate())>=121),0) 'F'
FROM JDT1 T0 INNER JOIN OCRD T1 ON T0.ShortName = T1.CardCode
Left outer join  OCTG T2 On T1.GroupNum = T2.GroupNum
WHERE  T1.CardType = 'C' 
) T100
GROUP BY CARDCODE, CARDNAME, PymntGroup
ORDER BY CARDCODE

推荐答案

检查数据库，并确保您的OCRD表包含一个名为Free_Text <的列br />
是用JDT1还是OCTG？

Check your database, and make sure that your OCRD table contains a column called Free_Text
Is it in JDT1 or OCTG instead?

这篇关于sql查询给出了无效的列名的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！