This should be straight forward, but I am getting my tail kicked with the proper syntax.
I have this syntax
Select DISTINCT bm.Location ,bm.[Beer (Upcoming Menu)] FROM ___SampleRequired bm LEFT JOIN ___Sample td ON LTRIM(RTRIM(bm.[Beer (Upcoming Menu)])) = LTRIM(RTRIM(td.Beer_name)) WHERE bm.Type LIKE '%Mandate%' AND bm.Location = 'StapleChase'
which I want to show all beer that exist in the SampleRequired Table that DO NOT exist in the Sample Table. When I execute the above query I get 24 results returned. My expected returned result set is 23 because
BLUE MOON BELGIAN WHITE
exists in both of the tables.
How should I change this query so that I ONLY get the results that exist in SampleRequired that DO NOT exist in Sample?
***Had to use pastebin bc SO complained my post was mostly code...sorry