I’ve been trying to improve my SQL and was playing around with a ‘NOT EXISTS’ function. I needed to find the names of salespeople who did not have any sales to company ‘RED’. I tried this and it did not work: This query ran but returned a NULL. Then I changed it to this and it worked fine: Can someone
Tag: notin
mysql query – clash between not in and/or
I’m trying to get all my products , from A specific categories and without some products from those categories . i did this query: The problem is that i’m still getting products with the string ‘SPLA’ or ‘SA OLP’ – because the NOT IN clash with the categories How to solve it ? Answer As a starter: always use standard
Data exclusions based on two-tables MS Access
I have table A which includes all data based on a read date. For example: Read Date—-Data 1/1/2016—–3 1/2/2016—–10 1/3/2016—–42 1/4/2016—–16 12/25/2016—-32 12/26/2016—-12 12/27/2016-…