您所在位置：主题：请问这个简单SQL查询语句有什么错
lifeng2007
[专家分：80] 发布于 2007-06-02 18:46:00
请求大家帮我看看这个简单SQL查询语句有什么错
use lifeng
select studentsnum,studentsname from studentslist
where studentslist.studentsnum=achievement.studentsnum
and achievement.achieve between 80 and 90
order by achieve desc
我搞了半天,下面都这样提示:
列前缀 'achievement' 与查询中所用的表名或别名不匹配。
use lifeng
select studentsnum,studentsname from studentslist
where studentslist.studentsnum=achievement.studentsnum
and achievement.achieve between 80 and 90
order by achieve desc
我搞了半天,下面都这样提示:
列前缀 'achievement' 与查询中所用的表名或别名不匹配。