SELECT DISTINCT

  • Thread starter Thread starter D.Logue
  • Start date Start date
D

D.Logue

SELECT DISTINCT [Last Name], [First Name], b.City
FROM Staff, Branch AS b;

I still get duplicates DISTINCT seems to have no effect on the
output?.
 
Hi,


Maybe there is spaces at the end of the names? Is a GROUP BY presents
the same behavior:

SELECT [Last Name], [First Name], b.City
FROM Staff, Branch AS b
GROUP BY [Last Name], [First Name], b.City



Hoping it may help,
Vanderghast, Access MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

SELECT DISTINCT 4
Use of DISTINCT 1
SELECT DISTINCT query 8
Deleting Duplicate Records 21
perform INNER JOIN on query results 2
Using word distinct in Count function. 2
select distinct fulladdress 2
NOT IN and Sub Query 2

Back
Top