请帮我看看有没有错？(50分)

C

cool_army

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2001-12-13

• #1

我写了如下一个sql语句，不过有错：
select Warrant_Form.Warrant_C,Fiscal_Name,sum(reckonings)
from Warrant_Form,Fiscal_Subject
where Warrant_Form.Warrrant_C=Fiscal_Subject.Fiscal_ID
group by Warrant_Form.Warrant_C
错误提示：
服务器: 消息 207，级别 16，状态 3，行 1
Invalid column name 'Warrrant_C'.

 

L

linglingx

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2001-12-13

• #2

检查你的服务器上面有没有这个字段！
初步怀疑是这个原因

 

Z

zjc

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2001-12-13

• #3

去掉Fiscal_Name字段试试
select Warrant_Form.Warrant_C,sum(reckonings)
from Warrant_Form,Fiscal_Subject
where Warrant_Form.Warrrant_C=Fiscal_Subject.Fiscal_ID
group by Warrant_Form.Warrant_C

 

白

白海森

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2001-12-13

• #4

你把Fiscal_Name去掉试试。

 

J

jackl

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2001-12-13

• #5

select Warrant_Form.Warrant_C,***.Fiscal_Name,sum(reckonings)
from Warrant_Form,Fiscal_Subject
where Warrant_Form.Warrrant_C=Fiscal_Subject.Fiscal_ID
group by Warrant_Form.Warrant_C,***.Fiscal_Name

 

C

cool_army

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2001-12-13

• #6

Fiscal_Name 是Fiscal_Subject的字段，而且这个字段肯定存在。

 

C

cool_army

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2001-12-14

• #7

谢谢各位的提示，我已成功该好了。