W3School TIY Editor

SELECT testproduct_id, product_name, category_name FROM testproducts RIGHT JOIN categories ON testproducts.category_id = categories.category_id;