I have two tables with identical fields(assignments, and matches).
However, only one of them accept NULL values for its fields. I want to
be able to find out all the matches for any assignment. The search
should retrun the match if the corresponding filed is NULL as well.
I wrote down the following code but it doesn’t return anything. I wonder
what I am doing wrong. Any help is greately appreciated.
:conditions => [‘matches.member_id IN (?, NULL) AND
matches.study_id IN (?, NULL) AND matches.tag_id IN (?, NULL)’,