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

来源:学生作业帮助网 编辑:六六作业网 时间:2024/12/25 02:37:19
SELECTS_student.*,kechengmingFROMS_student,courseWHERES_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(*);
帮忙看一下这语句怎么总执行错误啊,说'*'附近有语法错误,郁闷啊,

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(+);
这个效果?