Is it possible to compare two lists in an SQL query? I have a rather complex query using joins and multiple criteria. Everything is working fine except the statement where the field queried (Norm::Sex) can contain more than one value (male and/or female). I’d like to get results if there is an intersection. The relevant part of the query looks like this:
FROM Norm AS n
WHERE n.Sex = ?
doesn’t work even if all entries in Norm::Sex are the same.