SELECT C.cat_name, P.prod_title FROM Category AS C FULL OUTER JOIN Products AS P ON C.cat_id= P.cat_id;