Unique Values with other data 1

[snyperx3]

Ive looked into the DISTINCT portion of SQL and im not too sure how to get this to work the way i want it to. I have a table that has item number and item description for each store. some stores have the same items as another store, so what im trying to do is get the query to pull the unique item numbers and get their description as well. Thanks for the help.

Pete

 

[Golom]

Don't know your fields or table structures but ...

Select DISTINCT A.ItemNo, A.Description

From tblItems As A

WHERE A.Store = 1 AND

      A.ItemNo NOT IN
      (Select B.ItemNo From tblItems B Where B.Store = 2)

 

[snyperx3]

Thanks, works great.

Pete