confirm if variable exists in table 2

[paul2877]

I have two data sets: January and February

I would like to know if the value apple is in the February Table based on multiple matching

January Table

Name  Event  Snack

Paul   Picnic   Apple

Paul   Picnic   Orange

Paul   Picnic  Grape

February Table

Name  Event  Snack

Paul   Picnic   Apple

Paul   Picnic   Bread

Paul   Picnic  Grape

The result I want is

Summary Table:

Name  Event  Snack Validation

Paul     Picnic  Apple    Yes

Paul     Picnic  Orange  No

Paul    Picni     Grape  Yes

I basically want to know if the snack is in the February table as well

[LinusH]

Use SQL left join, and use CASE statement to see if there is a matching value from February table.