如何写这样的查询语句？(50分)

D

dreameast-1

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2006-04-01

• #1

select inno as入库编号 moldcode as模具编号 from sld_main
我的意思是将数据库中的字段转换为中文显示，以上的写法为什么总提示语法错误阿？
我用的是access数据库

 

S

suger

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2006-04-01

• #2

select inno as '入库编号' moldcode as '模具编号' from sld_main

 

D

dreameast-1

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2006-04-01

• #3

还是有错误阿
[Error] u_mjrkquery.pas(64): Illegal character in input file: '入' ($C8EB)

 

M

myid0602

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2006-04-02

• #4

select inno as 入库编号,moldcode as 模具编号 from sld_main

 

D

dreameast-1

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2006-04-02

• #5

照楼上修改后字段一多还是出报警
如：select inno as 入库编号,moldcode as 模具编号 ,moldname as模具名称 ,moldsize as 模具规格, outdate as出库日期, outperson as 出库人 ,yuansum as原料数量 ,chengsum as成品数量, bansum as半成品数量,from sld_main

出错提示为？格式不对，或使用了保留的关键字？？？

 

漂

漂流的雲

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2006-04-03

• #6

select inno as 入库编号,moldcode as 模具编号 ,moldname as 模具名称 ,moldsize as 模具规格, outdate as 出库日期, outperson as 出库人 ,yuansum as 原料数量 ,chengsum as 成品数量, bansum as 半成品数量 from sld_main

 

C

chendy095

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2006-04-03

• #7

select inno as 入库编号,moldcode as 模具编号 ,moldname as模具名称 ,moldsize as 模具规格, outdate as出库日期, outperson as 出库人 ,yuansum as原料数量 ,chengsum as成品数量, bansum as半成品数量 from sld_main

你的语法错误，你看看是不是有多余的逗号或者少逗号

 

秃

秃鹰

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2006-04-03

• #8

from 前面的逗号去掉应该就可以了

 

D

dreameast-1

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2006-06-13

• #9

多人接受答案了。