Example question:

I have a table called Candy, with thousands of records, and has 10 columns with information about the candy. I want to pull up the data for 3 records, and I have the following information:

1. Candy 1: Color = Yellow, Type = Soft, Flavor = Lemon
2. Candy 2: Color = Yellow, Type = Hard, Flavor = Lemon
3. Candy 3: Color = Red, Type = Hard, Flavor = Cherry

How do I do this? In Psuedo-CodeEnglish, it would be:

```
Select *
From Candy
WHERE (Color = Yellow, Type = Soft, Flavor = Lemon)
AND (Candy 2: Color = Yellow, Type = Hard, Flavor = Lemon)
AND (Color = Red, Type = Hard, Flavor = Cherry);

```

But that doesn't work for me. I'm using PL/SQL.