**TableA**
select `Contact Email Address`,
`Contact First Name`
FROM Test_1
**Table B**
select TableA.`Contact Email Address`,
case when TableA.`Contact Email Address` IS NOT NULL THEN 'Match'
ELSE'No Match'
END as 'NA'
from `Table A`
left JOIN `Products` ON `Table A`.`Contact Email Address`='Products.`Contact Email Address`
Trying to get the two o/p into one single query
Select count(*)
from Table A
SELECT COUNT(*)
from 'TableB'
where `NA`= 'No Match'
Products
, the join criteria doesn't make a difference to the result as its a left join. – danblack Dec 16 '19 at 2:46