Simple distinctrow issue

[mhoek74]

OK, this seems simple enough...I would like to get distinct rows from the following query:

SELECT DISTINCTROW Query1.[Managers First Name], Query1.[Managers Last Name]
FROM Query1 INNER JOIN Table1 ON (Query1.[Managers Last Name] = Table1.[Last Name]) AND (Query1.[Managers First Name] = Table1.[First Name]);

Instead, I am getting all rows returned.

Any ideas? Thanks!
Mike

 

[swampBoogie]

What does you mean by distinct rows?

Give some sample data and the expected result.

 

[mhoek74]

Here are some results from this query...

Kirk Stevenson
Kirk Stevenson
Alton Jones
Daniel Harlewicz
Kevin Kones
Kevin Kones
Kevin Kones
Kevin Kones
Kevin Kones

I would expect to only see...

Kirk Stevenson
Alton Jones
Daniel Harlewicz
Kevin Kones

Thanks,
Mike

 

[swampBoogie]

Use distinct instead of distinctrow

 

[mhoek74]

That was it! (Why couldn't I think of that?)

Maybe someone could explain this to me...because I thought distinct would only give me a single distinct column (like in my example all distinct first names) while you needed the distinct row for the operator to look at all columns.

Thanks