select p.prod_name, o.order_num
from Products p 
left join OrderItems o on p.prod_id = o.prod_id
order by p.prod_name;

MySQL中的outer join分为left join、right join、full join。内连接inner join返回的是两个表匹配的行，而外连接返回的是所有行。