Tip: Finding products which do not have a category mapping

SELECT  Product.Id, Product.SKU, product.Name
FROM    Product
WHERE   NOT EXISTS
        (
        SELECT  NULL
        FROM    Product_Category_Mapping t1
        WHERE   (t1.ProductId = Product.Id)
        )
    AND product.Deleted=0