confirm if variable exists in table 2

paul2877 — Thu, 02 Mar 2017 03:42:33 GMT

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

Re: confirm if variable exists in table 2

LinusH — Thu, 02 Mar 2017 08:57:24 GMT

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