错误代码： 1248 Every derived table must have its own alias

来源：互联网发布：pushkit python 编辑：程序博客网时间：2024/05/17 05:06

1、错误描述

1 queries executed, 0 success, 1 errors, 0 warnings查询：SELECT stu_id, (SELECT stu_name FROM t_student_info t WHERE t.stu_id = t.stu_id) stu_name FROM (SELECT SUM( CASE course WHEN '敮..错误代码： 1248Every derived table must have its own alias执行耗时   : 0 sec传送时间   : 0 sec总耗时      : 0 sec

2、错误原因

SELECT   stu_id,  (SELECT     stu_name   FROM    t_student_info t   WHERE t.stu_id = t.stu_id) stu_name FROM  (SELECT     SUM(      CASE        course         WHEN '数学'         THEN Score         ELSE 0       END    ) 数学,    SUM(      CASE        course         WHEN '语文'         THEN score         ELSE 0       END    ) 语文,    SUM(      CASE        course         WHEN '英语'         THEN score         ELSE 0       END    ) 英语,    stu_id   FROM    t_score_info   GROUP BY stu_id)

3、解决办法

SELECT*FROM(SELECTstu_noFROMt_student_infoUNIONSELECTstu_noFROMt_student_info) student;

在后面给联合查询取个别名student

1 0