急：恳求教师更正一下SQL语句错误，多谢！

lucky7678

select 姓名,0 as 性别,0 as 出生时间,0 as 级数,0 as 08薪级 from [04$] union all select 姓名,0 as 性别,0 as 出生时间,0 as 级数,0 as 08薪级 from [05$] union al lselect 姓名,0 as 性别,0 as 出生时间,0 as 级数,0 as 08薪级 from [06$] union all select 姓名,0 as 性别,0 as 出生时间,0 as 级数,0 as 08薪级 from [07$] union all select 姓名,性别,出生时间,级数,08薪级 from [08$]

zhaozyuan

select 姓名,0 as 性别,0 as 出生时间,0 as 级数,0 as 08薪级 from [04$] union all select 姓名,0 as 性别,0 as 出生时间,0 as 级数,0 as 08薪级 from [05$] union al lselect 姓名,0 as 性别,0 as 出生时间,0 as 级数,0 as 08薪级 from [06$] union all select 姓名,0 as 性别,0 as 出生时间,0 as 级数,0 as 08薪级 from [07$]
你选那么多0干什么用？？

亡者天下

楼主最好把你的附件上传！

lucky7678

原帖由 亡者天下 于 2009-12-14 23:42 发表
楼主最好把你的附件上传！

有劳您请修正一下，多谢！

masterexcel

这个帖里面我的回复也不见了！今天下午的网站维护丢了些数据！

lucky7678

已阅过！但我没法处理好。多谢！