You need
left join PostedRecipes to pictures or ratings in order to get the results you want. Inner join only selects the matching rows, while left join selects the matching rows or null if the row on the left doesn't have any match on the right.
SELECT PostedRecipes.RecipeID, PostedRecipePictures.RecipeID AS Expr1
FROM PostedRecipes
LEFT JOIN PostedRecipePictures
ON PostedRecipes.RecipeID = PostedRecipePictures.RecipeID
WHERE PostedRecipePictures.RecipeID IS NULL
Alternatively you can rewrite the query using NOT EXISTS
SELECT PostedRecipes.RecipeID
FROM PostedRecipes
WHERE NOT EXISTS (
SELECT * FROM PostedRecipePictures
WHERE PostedRecipePictures.RecipeID = PostedRecipes.RecipeID
)