1. left join表orders,匹配行数为0,表orders以字段全为null的形式存在
select cus.cust_name,ord.order_num
from customers cus left join orders ord
on cus.cust_id = ord.cust_id and cus.cust_id = 1010;
2. if函数使用,没有as,列名为表达式名
select cus.cust_name,
if(ord.order_num is null,0,ord.order_num) as order_num
from customers cus left join orders ord
on cus.cust_id = ord.cust_id and cus.cust_id = 10001;