Using Access to join to simple Tables...



SQL:



SELECT DISTINCT MCF.StandardID, MCF.Standard, MCF.BenchmarkID, 

MCF.Benchmark, NCO.Area, NCO.Grade, NCO.NCO, NCO.Desc

FROM NCO INNER JOIN MCF ON (NCO.Benchmark = MCF.BenchmarkID) AND 

(NCO.Standard = MCF.StandardID)

ORDER BY MCF.StandardID, MCF.BenchmarkID, NCO.Area, NCO.Grade, NCO.NCO;



Output is giving me four duplicate copies of each row....All the data is 

exactly the same, but in the table there is only one entry...(doesn't the 

DISTINCT work, or am I using it improperly???)

What am I missing??

Thanks,

Rick