SELECT DISTINCT

[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?.

 

[Michel Walsh]

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