select  prod_name,order_num
from Products t left join OrderItems t1 on t.prod_id=t1.prod_id
order by prod_name

题目说到的 OUTER JOIN 即为LEFT OUTER JOIN
平时略写为 LEFT JOIN