力扣183从不订购的客户leetcode183从不订购的客户

分析:

找出所有从不点任何东西的顾客

输入

Customers 表

Orders 表

输出

id

name

id

customerId

Customers

1

Joe

1

3

Henry

2

Henry

2

1

Max

3

Sam

4

Max

以customers表为中心表左连 接order表能够显示出下单和没有下单的顾客 select * from customers c left join order o on c.id = o.customerid

c.id

c.name

o.id

o.customerId

最后加一个o.customerid is null 条件. select c.name Customers from customers c left join orders o on c.id=o.customerid where o.customerid is null

Customers

1

Joe

2

1

Henry

3

Sam

1

3

Max

2

Henry

null

null

4

Max

null

null

实现:

select
    c.name Customers 
from customers c
    left join orders o on c.id=o.customerId
where o.id is null;