From: Graham Anderson
Date: March 31 2005 11:17pm
Subject: Newbie: MYSQL nested query question
List-Archive: http://lists.mysql.com/mysql/181990
Message-Id: <4dc50f958e72841747300ff253e5200f@siren.cc>
MIME-Version: 1.0 (Apple Message framework v619.2)
Content-Type: text/plain; charset=US-ASCII; format=flowed
Content-Transfer-Encoding: 7bit

What is the proper way to say this ?

SELECT C.City, N.Distance
FROM Cities C
JOIN Nearbycities N ON C.CityId = N.PrimaryCityId
WHERE  N.CityId =
(SELECT Cities.CityId FROM Cities WHERE Cities.city = 'Los Angeles')
AND N.distance < 20

I am trying to enter in a city and get all the nearby cites with 20 
miles
Somehow, I need to join NearbyCities.PrimaryCityId, Cities.CityId, and 
Cities.city

learning :)