I'm trying to construct this query using sql in microsoft access, and I'm having a little trouble finding a way to do it.I have an items-sold table that looks similar to this:
item_name department-------------------------------------------------Geo positioning system NavigationMap measure NavigationGeo positioning system BooksSextant BooksPocket knife-Nile BooksPocket knife-Nile Clothes
I need build a query that list departments that have not sold a Geo position system. Any ideas?