Confusing SQL query 1

[int3grate]

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                Navigation
Map measure                           Navigation
Geo positioning system                Books
Sextant                               Books
Pocket knife-Nile                     Books
Pocket knife-Nile                     Clothes

I need build a query that list departments that have not sold a Geo position system. Any ideas?

 

[SkipVought]

Hi,
[code[
SELECT department
FROM `Data$`
WHERE department Not IN
(
SELECT department
FROM `D:\My Documents\vba\query stuff B`.`Data$` `Data$`
WHERE item_name='Geo positioning system'
)
[/code]

Skip,

_[red][/red]

 

[int3grate]

Thanks Skip, thats exactly what I was looking for!