SELECT S_student.*,kechengming FROM S_student,course WHERE S_student.xuehao = course.xuehao(*);帮忙看一下这语句怎么总执行错误啊,说'*'附近有语法错误,郁闷啊,

来源:学生作业帮助网 编辑:作业帮 时间:2024/11/16 14:28:51

SELECT S_student.*,kechengming FROM S_student,course WHERE S_student.xuehao = course.xuehao(*);帮忙看一下这语句怎么总执行错误啊,说'*'附近有语法错误,郁闷啊,
SELECT S_student.*,kechengming FROM S_student,course WHERE S_student.xuehao = course.xuehao(*);
帮忙看一下这语句怎么总执行错误啊,说'*'附近有语法错误,郁闷啊,

SELECT S_student.*,kechengming FROM S_student,course WHERE S_student.xuehao = course.xuehao(*);帮忙看一下这语句怎么总执行错误啊,说'*'附近有语法错误,郁闷啊,
如果是 Oracle 的话,
SELECT S_student.*,kechengming FROM S_student,course WHERE S_student.xuehao = course.xuehao(+);
这个效果?