Designing a query from another query but by retaining only unique values

[accessaspire219]

Hi,
I have a query (say query1) which contains item numbers and their stock levels at various locations. The item numbers appear multiple times since they are stocked at multiple locations. I want to design another query (query 2) based on this query by joining the item number columns however, I want it such that only unique item number from query 1 are matched to those in query 2. (all unique item numbers from query 1 should be matched to the item numbers in query 2)
Does any one know what kind of join or expression or criterion this would need?
Thanks.

 

[accessaspire219]

Thanks uncle gizmo. I'll try that and let you know.