Removing duplicate results from query

[r3volver]

Here's my code:

SELECT [FET].[Material], [FET].[Material_Description], [FET].[Product_hierarchy], [80KS].[Material], [80KS].[Material_Description], [80KS].[Product_hierarchy]
FROM FET, 80KS
WHERE [FET].[Product_hierarchy]=[80KS].[product_hierarchy];

The problem is, there can be tons of records in the 80KS query that have a Product_hierarchy matching up to the records in the FET query. And they will have a different Material and Material_Description. So they're not duplicates as far as Access is concerned.

I only want one 80KS record matching up to an FET record. I don't care which one. How do I do it?

Any help you can toss my way is appreciated.

 

[giacomo]

do a totals query and choose FIRST or LAST for your 80KS fields

hth,
Giacomo