I have two tables:
Both have the column brand.
I want all the duplicate brands from AutoCoupons with the source shoprite.com from CouProducts.
Here is what I was trying
select * from `couProducts` where `brand` in (select 'brand' from `autoCoupons` where `service` = "Shoprite.com");
This is not working. Can anyone help?