Hi, I have a query where I'm using a left outer join to connect two tables, entries and entries_tags, where entries_tags is a join table between entries and another table, tags. In my query I am selecting values from the entries table where the entries have any of the provided tags - WHERE entries_tags.tag_id IN (x, y, z)
What I would like to do is switch this from an OR condition to an AND condition, so that an entry is only returned if it has all of x, y, and z. How would I go about doing this? Thanks, Simon