MySQL, SQL Select Statement, Where with OR... What's wrong with this?
- by nobosh
I'm looking for help with my query below. which is never returning anything for veggie... Is the way I have my WHERE statement written valid?
SELECT *
FROM newsfeed INNER JOIN newsfeedaction ON newsfeed.newsfeedactionid = newsfeedaction.newsFeedActionID
INNER JOIN person ON newsfeed.personID = person.personID
LEFT OUTER JOIN food ON newsfeed.foodID = food.foodID
LEFT OUTER JOIN veggie ON newsfeed.veggieID = veggie.veggieID
WHERE
(
newsfeed.veggieID IS NOT NULL
AND veggie.deleted = 'N'
)
OR
(
newsfeed.foodID IS NOT NULL
AND food.deleted = 'N')
