MySql Count 不能显示 0 个值

MySql Count cannot show 0 values(MySql Count 不能显示 0 个值)
本文介绍了MySql Count 不能显示 0 个值的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着跟版网的小编来一起学习吧!

问题描述

我有两张桌子一张员工和邮寄订阅员工看起来像这样:

I have two tables one Employee and mailing Subscriptions Employee looks like this:

姓名 (pk) |姓氏 |年龄

Name (pk) | Surname | Age

邮寄订阅

MailId (pk)|员工姓名 (fk)|描述 |日期

MailId (pk)| EmployeeName (fk)|Description | Date

我想为每个客户提供订阅号,因此我尝试了以下查询:

I wanted to subscription number for each customer, therefore I tried the following query:

Select COUNT(c.Name) 
From Employee 
    INNER JOIN mailingSubscriptions as m ON c.Name = m.EmployeeName;

它将为我提供在邮件订阅中具有条目的每个员工的所有计数.

It will give me all counts for each Employee that has an entry in the mailing subscription.

我的问题是我想查看所有员工的计数,包括没有条目的员工(因此显示为 0),我尝试了外部左/右连接,但它不起作用.难道我做错了什么?

My problem is that I want to see the counts for ALL the Employees, including the ones without an entry (therefore to show 0), I tried an outer left/right join, but it will not work. Am I doing something wrong?

推荐答案

SELECT c.name, count(m.mailid)
FROM Employee 
   LEFT JOIN mailingSubscriptions as m ON c.Name = m.EmployeeName
GROUP BY c.name;

这篇关于MySql Count 不能显示 0 个值的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持跟版网!

本站部分内容来源互联网,如果有图片或者内容侵犯了您的权益,请联系我们,我们会在确认后第一时间进行删除!

相关文档推荐

Can#39;t Create Entity Data Model - using MySql and EF6(无法创建实体数据模型 - 使用 MySql 和 EF6)
MySQL select with CONCAT condition(MySQL选择与CONCAT条件)
Capitalize first letter of each word, in existing table(将现有表格中每个单词的首字母大写)
How to retrieve SQL result column value using column name in Python?(如何在 Python 中使用列名检索 SQL 结果列值?)
Update row with data from another row in the same table(使用同一表中另一行的数据更新行)
Exporting results of a Mysql query to excel?(将 Mysql 查询的结果导出到 excel?)