I have a query that picks up checked boxes from a lookup table where a userid is associated with a corresponding lookup value.
table1
id | value
1 | Chicken
2 | Steak
3 | Tunafish
4 | Ostrich
table2
userid | likes
1 | 1
1 | 2
1 | 4
2 | 4
3 | 4
... | ...
4000 | 1
4000 | 3
How would the SQL statement appear to select the rows that the userid doesn't like? for instance, How would I do a search to associate Steak and Ostrich with userid 4000?
