mysql不支持outer join，所以用left join代替

select prod_name,
order_num
from Products
left join  OrderItems
using(prod_id)
order by prod_name