SELECT S_student.*,kechengming FROM S_student,course WHERE S
来源:学生作业帮 编辑:拍题作业网作业帮 分类:综合作业 时间:2024/05/13 15:39:28
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(+);
这个效果?
再问: 但是我用的SQL
再答: SQL Server 的话. 那应该是 SELECT S_student.*,kechengming FROM S_student LEFT JOIN course ON ( S_student.xuehao = course.xuehao );
SELECT S_student.*,kechengming FROM S_student,course WHERE S_student.xuehao = course.xuehao(+);
这个效果?
再问: 但是我用的SQL
再答: SQL Server 的话. 那应该是 SELECT S_student.*,kechengming FROM S_student LEFT JOIN course ON ( S_student.xuehao = course.xuehao );
SELECT S_student.*,kechengming FROM S_student,course WHERE S
select s.name,s.course,s.grade from student as s inner join
select * from teacher where s_id in(select s_id from student
select * from order where clientNo in (select distinct(clien
英语翻译select top 4 * from shop_books where anclassid = (select
SELECT student_id FROM tuition where student_id in ( SELECT
oracle 子查询:select *,(select account from t_ps_member m where
select * from user_info where user_name in (select user_name
select * into b from a where 11
select * from book where 1=1
SQL 语句 "SELECT * FROM {{table}} WHERE `fleet_end_time`
ms sql :select * from (select *from b) as xxx where 和 select