[MySQL] left join, left outer join

없음. 줄여쓰는 것임.

https://leetcode.com/problems/customers-who-never-order/

Customers Who Never Order - LeetCode

select name as Customers
from Customers as a
left outer join Orders as b
on a.id = b.customerId
where b.id is null

select c.name as Customers
from Customers c
left join Orders o
on c.id = o.CustomerId
where  o.CustomerId IS NULL

Reference

http://gnujava.com/board/article_view.jsp?article_no=726&board_no=23&table_cd=EPAR06&table_no=06 

GNUJAVA