Simple Query?

I do I select all the customers from the same city? I thought it would be like this:

SELECT C.Name, C.City
FROM Customer C, Customer Ca
WHERE C.City = Ca.City

But I get an unexpected result. Received on Tue May 29 2001 - 03:10:54 CDT