filtering for multiple values on one column. All values must exist, else - return zero
- by Andrew
Hello All,
I would like to filter one column in a table for couple values and show results only if all those values are there. If one or more is missing, then return zero results.
example table
+----+--------+----------+
| id | Fruit | Color |
+----+--------+----------+
| 1 | apple | red |
| 2 | mango | yellow |
| 3 | banana |…