select infostudent.xm,diclesson1.des as desLesson1,diclesson2.des as desLesson2 from (infostudent left join diclesson as diclesson1 on infostudent.lesson1=diclesson1.code) left join diclesson as diclesson2 on infostudent.lesson2=diclesson2.code
应该是sql语句写的不正确的缘故 表绝对没问题的
上面错了,不好意思,应该如下: select infostudent.xm,diclesson1.des as desLesson1,diclesson2.des as desLesson2 from (infostudent left join diclesson diclesson1 on infostudent.lesson1=diclesson1.code) left join diclesson diclesson2 on infostudent.lesson2=diclesson2.code
提示错误是: 缺少select关键字 在 from......
select infostudent.xm,diclesson1.des as desLesson1,diclesson2.des as desLesson2 from infostudent,diclesson diclesson1,diclesson diclesson2 where infostudent.lesson1=diclesson1.code and infostudent.lesson2=diclesson2.code
desLesson2
from (infostudent left join diclesson as diclesson1 on infostudent.lesson1=diclesson1.code) left join diclesson as diclesson2
on infostudent.lesson2=diclesson2.code
表绝对没问题的
select infostudent.xm,diclesson1.des as desLesson1,diclesson2.des as
desLesson2
from (infostudent left join diclesson diclesson1 on infostudent.lesson1=diclesson1.code) left join diclesson diclesson2
on infostudent.lesson2=diclesson2.code
缺少select关键字
在
from......
desLesson2
from infostudent,diclesson diclesson1,diclesson diclesson2
where infostudent.lesson1=diclesson1.code
and
infostudent.lesson2=diclesson2.code