sql - 自己加入一个表

Question

 CustID       Name         ReferredBy
 1         Neeta Sayam  
 2         Dolly Dilly         1
 3         Meena Kimi          2

查找其他人推荐的所有客户的姓名。

输出应该是 dolly dilly 和 meena kimi。

我已经通过查询成功找到了给别人转过的客户

 SELECT c1.name FROM Customer c1 JOIN Customer c2 ON c1.custid=c2. ReferredBy

Answer 1

除非我遗漏了什么:

SELECT *
FROM Customer
WHERE ReferredBy IS NOT NULL