```
category    item
red         pen
red         ball
blue        kite
blue        toy
shiny       pen

```

I want to get all items that are red OR blue AND they have to be shiny.

Here is my query so far

```
SELECT DISTINCT item FROM mytable WHERE category IN ("red","blue")

```

This get all of the red and blue items but how can I specify that the item must also be shiny? Adding shiny to the IN statement would still return all the blue items. The blue items should be excluded because none of them have a shiny entry in the database. 

With my example, only pen should be returned. Any help would be very much appreciated.