SELECT COUNT(*),family from
(SELECT family,book FROM father_book f
LEFT JOIN family fa ON f.father =fa.father
union all
SELECT family,book FROM mather_book f
LEFT JOIN family fa ON f.mather =fa.mather
union all
SELECT family,book FROM child_book f
LEFT JOIN family fa ON f.child =fa.child) a GROUP by family;
(SELECT family,book FROM father_book f
LEFT JOIN family fa ON f.father =fa.father
union all
SELECT family,book FROM mather_book f
LEFT JOIN family fa ON f.mather =fa.mather
union all
SELECT family,book FROM child_book f
LEFT JOIN family fa ON f.child =fa.child) a GROUP by family;
解决方案 »
- 查询出各年龄段人并且该年龄段的人数大于3才被返回,降序,0到10条.请问怎么写命令,谢谢
- 关于DB恢复问题
- 数据库权限问题
- 表行数据复制 mysql
- 一个日期查询的写法?求助
- 请教:RedLinux9下的Mysql安装具体过程(看过手册,可是还是不行),谢谢!
- 查寻语句如何写
- 最近刚工作 用到mysql有一些疑问 关于 批量删除 表中的数据
- 本地的mysql数据库打不开了,我打开 http://localhost/phpmyadmin/,错误提示如下。该咋办?
- 求会mysql的帮忙看下,为什么同一段sql查询语句mssql和mysql差距这么大
- 请教一SQL语句
- update语句导致的lock错误Lock wait timeout exceeded; try restarting transaction?
(SELECT family,book FROM father_book f
LEFT JOIN family fa ON f.father =fa.father
union
SELECT family,book FROM mather_book f
LEFT JOIN family fa ON f.mather =fa.mather
union
SELECT family,book FROM child_book f
LEFT JOIN family fa ON f.child =fa.child) a GROUP by family;