#outer join = left join and right join

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