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
 
Back
Top