MySQL联表统计查询报错“Every derived table must have its own alias”

最新推荐文章于 2024-08-09 05:15:00 发布

TEAVAMC

最新推荐文章于 2024-08-09 05:15:00 发布

阅读量2.9k

点赞数 1

分类专栏：【Java基础】

本文链接：https://blog.csdn.net/teavamc/article/details/86709542

版权

【Java基础】专栏收录该内容

25 篇文章 1 订阅

订阅专栏

MySQL联表统计查询报错 Every derived table must have its own alias

意思就是派生表需要加个别名，参照我的原SQL

select * from
  (select
      count(pid) as msum,
      count(sex = '男' or null ) as mman,
      count(sex = '女' or null ) as mwoman
    from myc_member),
  (select
      count(pid) as psum,
      count(sex = '男' or null ) as pman,
      count(sex = '女' or null ) as pwoman
    from myc_partymember)

这就报错了，给个名字后

select * from
  (select
      count(pid) as msum,
      count(sex = '男' or null ) as mman,
      count(sex = '女' or null ) as mwoman
    from myc_member) as one,
  (select
      count(pid) as psum,
      count(sex = '男' or null ) as pman,
      count(sex = '女' or null ) as pwoman
    from myc_partymember) as tow