select prod_name,order_num from Products A
left join OrderItems B
on A.prod_id=B.prod_id
union
select prod_name,order_num from Products C
right join OrderItems D
on C.prod_id=D.prod_id
where C.prod_id is null
order by prod_name